Authorization problems with SQL Developer's edition

I just installed developer's edition on a new laptop. Other machines in the
network cannot connect to this new instance.
At first it was TIMEOUTS - so I turned off the new WINDOWS firewall feature
(we are inside a small network anyway - no need for local firewalls - I
guess).
Then it was trying to connect as USERNAME = GUEST. I found GUEST as a
username under COMPUTER MANAGEMENT and disabled it.
Now it's getting login failed for user NULL.
Seems it's not on the network like the old laptop was. The old laptop did
not authenticate to the network, it logged in locally, but the SQL instance
was visible and connectable.
I cannot seem to add DOMAIN\usernames to this instance.
Any direction would be greatly appreciated.I would try to connect to it via its IP address using a SQL Server login just
in case it is a DNS issue. Just a thought...
--
Thomas
"Steve Z" wrote:
> I just installed developer's edition on a new laptop. Other machines in the
> network cannot connect to this new instance.
> At first it was TIMEOUTS - so I turned off the new WINDOWS firewall feature
> (we are inside a small network anyway - no need for local firewalls - I
> guess).
> Then it was trying to connect as USERNAME = GUEST. I found GUEST as a
> username under COMPUTER MANAGEMENT and disabled it.
> Now it's getting login failed for user NULL.
> Seems it's not on the network like the old laptop was. The old laptop did
> not authenticate to the network, it logged in locally, but the SQL instance
> was visible and connectable.
> I cannot seem to add DOMAIN\usernames to this instance.
> Any direction would be greatly appreciated.|||I am not a network person - and it really does show sometimes...
I did not join the domain properly with this new laptop.
Now that I've done that it's all set...
"Thomas" wrote:
> I would try to connect to it via its IP address using a SQL Server login just
> in case it is a DNS issue. Just a thought...
> --
> Thomas
>
> "Steve Z" wrote:
> > I just installed developer's edition on a new laptop. Other machines in the
> > network cannot connect to this new instance.
> >
> > At first it was TIMEOUTS - so I turned off the new WINDOWS firewall feature
> > (we are inside a small network anyway - no need for local firewalls - I
> > guess).
> >
> > Then it was trying to connect as USERNAME = GUEST. I found GUEST as a
> > username under COMPUTER MANAGEMENT and disabled it.
> >
> > Now it's getting login failed for user NULL.
> >
> > Seems it's not on the network like the old laptop was. The old laptop did
> > not authenticate to the network, it logged in locally, but the SQL instance
> > was visible and connectable.
> >
> > I cannot seem to add DOMAIN\usernames to this instance.
> >
> > Any direction would be greatly appreciated.

Authentication problem

Hi,
First of all I would like to thank you in advance for all your time given to
my problem.
I'll try to explain our problem.
In our network we have several servers all with W2K SERVER.
SERVER 1 is DCP
SERVER 2 is DC
SERVER 3 is running SQL server standalone
SERVER 4 is running SQL server getting data from SERVER 2
SERVER 4 has several users defined as LOCAL and is supposed to get all AD
users but (and here is the problem) it doesn't.What I've found is that
SERVER 4 takes AD users from SERVER 3 and this one has some users missing
(all of them created after an specific date). The big problem is that the
users "most wanted" can't access OLAP cubes and I can't find a way to give
SERVER 4 those users.
Before that "day" SERVER 3 was a DC and now it isn't, so the AD information
is not replied to this server. Is there any way for SQL SERVER (or SERVER 4)
to get the whole AD information directly from SERVER 1 (or 2) without
promoting SERVER 4 to DC.
Thanks again
Alvaro Ruiz
URENDE, S.A.
alvaro.ruiz@.urende.es
Note: I'm not a expert in this so, I beg your pardon if I wrote something
that is not correct or if I have a wrong idea of how this works.Hi
Shutdown Server 3, Reboot Server 4 and see if you are getting the full list.
How was Server 3 turned into a stand alone server,after is was a DC? DCPROMO
or just a re-install without running DCPROMO first? If it was a re-install,
AD will still show it as a DC.
Regards
Mike
"Alvaro Ruiz" wrote:

> Hi,
> First of all I would like to thank you in advance for all your time given
to
> my problem.
> I'll try to explain our problem.
> In our network we have several servers all with W2K SERVER.
> SERVER 1 is DCP
> SERVER 2 is DC
> SERVER 3 is running SQL server standalone
> SERVER 4 is running SQL server getting data from SERVER 2
> SERVER 4 has several users defined as LOCAL and is supposed to get all AD
> users but (and here is the problem) it doesn't.What I've found is that
> SERVER 4 takes AD users from SERVER 3 and this one has some users missing
> (all of them created after an specific date). The big problem is that the
> users "most wanted" can't access OLAP cubes and I can't find a way to give
> SERVER 4 those users.
> Before that "day" SERVER 3 was a DC and now it isn't, so the AD informatio
n
> is not replied to this server. Is there any way for SQL SERVER (or SERVER
4)
> to get the whole AD information directly from SERVER 1 (or 2) without
> promoting SERVER 4 to DC.
> Thanks again
> Alvaro Ruiz
> URENDE, S.A.
> alvaro.ruiz@.urende.es
>
> Note: I'm not a expert in this so, I beg your pardon if I wrote something
> that is not correct or if I have a wrong idea of how this works.
>
>sql

Authenticating users with Active Directory and SQL Server 2000

I've set up a web page on our network that links to an SQL Server database c
ontaining records of staff members. At the moment the web page extracts all
the rows from the table and shows all the staff records.
I want to be able to authenticate staff members using Active Directory, so w
hen they log onto their PC and access the webpage on our intranet they can O
NLY view their record from the database.
I'm just starting out with SQL Server and Active Directory, so any help woul
d be appreciated. From what I have read I think that I may need to use LDAP
to retrieve the Active Directory information.
Thanks in advance for your help.Use Windows Authentication for your web site, which will authorize the user
through AD. Then use integrated security/impersonation to pass the user
credentials to SQL for authorization and connection. Then, you can use the
USER_NAME (or similar technique) to filter the rows returned by any SQL
statement.
Hope this helps you get started...
"Enterprise Andy" <EnterpriseAndy@.discussions.microsoft.com> wrote in
message news:CBD3FEF9-ACF1-4979-9A90-4B4AF44B23C9@.microsoft.com...
> I've set up a web page on our network that links to an SQL Server database
containing records of staff members. At the moment the web page extracts all
the rows from the table and shows all the staff records.
> I want to be able to authenticate staff members using Active Directory, so
when they log onto their PC and access the webpage on our intranet they can
ONLY view their record from the database.
> I'm just starting out with SQL Server and Active Directory, so any help
would be appreciated. From what I have read I think that I may need to use
LDAP to retrieve the Active Directory information.
> Thanks in advance for your help.

Attempts to made backup on the network drive are failed

MS SQL Server 2000 Enterprise Edition Service Pack 3
on MS Windows Advanced Server Service Pack 4
Attempts to made backup on the network drive are failed.
There are two databases with this feature. One has 1400Mb data and 100Mb
log. Another has 4410Mb data and 1000Mb log.
First database has about 80% successful attempts. Second - only 10%. However
there are a lot of databases about 300-500Mb that are backed up successfully
always and one that has 4100Mb data and 1000Mb log, that is backed up
successfully always.
Backups on the local drives are always successful.
Copying entire catalog \data (about 20Gb mdf and ldf files) on the same
network drive is always successful.
Symptoms:
After issuing this statement:
backup database LargeDB to
disk='\\server001\backup2\mssql\LargeDB_20031209.bak' with stats=1
we have result:
1 percent backed up.
2 percent backed up.
3 percent backed up.
................
97 percent backed up.
98 percent backed up.
99 percent backed up.
Processed 563608 pages for database 'LargeDB', file 'LargeDBData' on file 1.
100 percent backed up.
Processed 1 pages for database 'LargeDB', file 'LargeDBlog' on file 1.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
SQL Server log contains two records:
BackupDiskFile::RequestDurableMedia: failure on backup device
'\\server001\backup2\mssql\LargeDB_20031209.bak'. Operating system error
64(error not found).
BACKUP failed to complete the command backup database LargeDB to
disk='\\server001\backup2\mssql\LargeDB_20031209.bak' with stats=1
Application event log contains two records:
18210 :
BackupDiskFile::RequestDurableMedia: failure on backup device
'\\server001\backup2\mssql\LargeDB_20031209.bak'. Operating system error
64(error not found).
3041 :
BACKUP failed to complete the command backup database LargeDB to
disk='\\server001\backup2\mssql\LargeDB_20031209.bak' with stats=1
System event log has no records
Events logs from file server has no records.
Attempt to restore from the "unsuccessful" backup file always is successful.
What should I do?|
| MS SQL Server 2000 Enterprise Edition Service Pack 3
| on MS Windows Advanced Server Service Pack 4
|
| Attempts to made backup on the network drive are failed.
| There are two databases with this feature. One has 1400Mb data and 100Mb
| log. Another has 4410Mb data and 1000Mb log.
| First database has about 80% successful attempts. Second - only 10%.
However
| there are a lot of databases about 300-500Mb that are backed up
successfully
| always and one that has 4100Mb data and 1000Mb log, that is backed up
| successfully always.
| Backups on the local drives are always successful.
| Copying entire catalog \data (about 20Gb mdf and ldf files) on the same
| network drive is always successful.
|
| Symptoms:
| After issuing this statement:
| backup database LargeDB to
| disk='\\server001\backup2\mssql\LargeDB_20031209.bak' with stats=1
| we have result:
| 1 percent backed up.
| 2 percent backed up.
| 3 percent backed up.
| ................
| 97 percent backed up.
| 98 percent backed up.
| 99 percent backed up.
| Processed 563608 pages for database 'LargeDB', file 'LargeDBData' on file
1.
| 100 percent backed up.
| Processed 1 pages for database 'LargeDB', file 'LargeDBlog' on file 1.
| Server: Msg 3013, Level 16, State 1, Line 1
| BACKUP DATABASE is terminating abnormally.
|
| SQL Server log contains two records:
| BackupDiskFile::RequestDurableMedia: failure on backup device
| '\\server001\backup2\mssql\LargeDB_20031209.bak'. Operating system error
| 64(error not found).
| BACKUP failed to complete the command backup database LargeDB to
| disk='\\server001\backup2\mssql\LargeDB_20031209.bak' with stats=1
|
| Application event log contains two records:
| 18210 :
| BackupDiskFile::RequestDurableMedia: failure on backup device
| '\\server001\backup2\mssql\LargeDB_20031209.bak'. Operating system error
| 64(error not found).
| 3041 :
| BACKUP failed to complete the command backup database LargeDB to
| disk='\\server001\backup2\mssql\LargeDB_20031209.bak' with stats=1
| System event log has no records
|
| Events logs from file server has no records.
|
| Attempt to restore from the "unsuccessful" backup file always is
successful.
|
| What should I do?
--
Go to the following registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanworkstation\param
eters\SessTimeout
Increase this value to 600 (10 minutes) and see how you go.
Hope this helps,
--
Eric Cárdenas
SQL Server support

Attempting to restore a db from a network drive and use the 'with move' statement

Attempting to restore a db from a network drive and need to move the
log file to a new location. CAN SOMEONE PLEAS REVIEW THE STATEMENTS
AND ERROR MESSAGES AND LET ME KNOW WHAT I AM DOING WRONG.
Here is the script that I am using for this procedure
===================================== USE MASTER
GO
RESTORE FILELISTONLY
FROM DISK = '\\NAS1\NASDisk\SQL Server\SQL Server Production
Backup\Indii DB'
RESTORE LOG Indii
FROM DISK = '\\NAS1\NASDisk\SQL Server\SQL Server Production
Backup\Indii DB'
WITH MOVE 'Indii_Log' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL$INDII_NY2_PROD\Data\Indii_Log.LDF'
-- WITH NORECOVERY
RESTORE DATABASE Indii
FROM DISK = '\\NAS1\NASDisk\SQL Server\SQL Server Production
Backup\Indii DB'
WITH NORECOVERY
=====================================
Here are the error(s) that I am receiving
===================================== Server: Msg 913, Level 16, State 8, Line 3
Could not find database ID 65535. Database may not be activated yet or
may be in transition.
Server: Msg 3013, Level 16, State 1, Line 3
RESTORE LOG is terminating abnormally.
Server: Msg 5105, Level 16, State 2, Line 7
Device activation error. The physical file name 'C:\Program
Files\Microsoft SQL Server\MSSQL$PRODUCTION\Data\\Indii_log.LDF' may be
incorrect.
Server: Msg 3156, Level 16, State 1, Line 7
File 'Indii_Log' cannot be restored to 'C:\Program Files\Microsoft SQL
Server\MSSQL$PRODUCTION\Data\\Indii_log.LDF'. Use WITH MOVE to identify
a valid location for the file.
Server: Msg 3013, Level 16, State 1, Line 7
RESTORE DATABASE is terminating abnormally.war_wheelan@.yahoo.com wrote:
> Attempting to restore a db from a network drive and need to move the
> log file to a new location. CAN SOMEONE PLEAS REVIEW THE STATEMENTS
> AND ERROR MESSAGES AND LET ME KNOW WHAT I AM DOING WRONG.
> Here is the script that I am using for this procedure
> =====================================> USE MASTER
> GO
> RESTORE FILELISTONLY
> FROM DISK = '\\NAS1\NASDisk\SQL Server\SQL Server Production
> Backup\Indii DB'
> RESTORE LOG Indii
> FROM DISK = '\\NAS1\NASDisk\SQL Server\SQL Server Production
> Backup\Indii DB'
> WITH MOVE 'Indii_Log' TO 'C:\Program Files\Microsoft SQL
> Server\MSSQL$INDII_NY2_PROD\Data\Indii_Log.LDF'
> -- WITH NORECOVERY
> RESTORE DATABASE Indii
> FROM DISK = '\\NAS1\NASDisk\SQL Server\SQL Server Production
> Backup\Indii DB'
> WITH NORECOVERY
> =====================================> Here are the error(s) that I am receiving
> =====================================> Server: Msg 913, Level 16, State 8, Line 3
> Could not find database ID 65535. Database may not be activated yet or
> may be in transition.
> Server: Msg 3013, Level 16, State 1, Line 3
> RESTORE LOG is terminating abnormally.
> Server: Msg 5105, Level 16, State 2, Line 7
> Device activation error. The physical file name 'C:\Program
> Files\Microsoft SQL Server\MSSQL$PRODUCTION\Data\\Indii_log.LDF' may be
> incorrect.
> Server: Msg 3156, Level 16, State 1, Line 7
> File 'Indii_Log' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$PRODUCTION\Data\\Indii_log.LDF'. Use WITH MOVE to identify
> a valid location for the file.
> Server: Msg 3013, Level 16, State 1, Line 7
> RESTORE DATABASE is terminating abnormally.
>
It looks like you're trying to restore the log before the database has
been restored. Restore the database first, THEN the log.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy,
The reason that I attempted to restore the log file first is because I
receive the same error either way.
Tracy McKibben wrote:
> war_wheelan@.yahoo.com wrote:
> > Attempting to restore a db from a network drive and need to move the
> > log file to a new location. CAN SOMEONE PLEAS REVIEW THE STATEMENTS
> > AND ERROR MESSAGES AND LET ME KNOW WHAT I AM DOING WRONG.
> >
> > Here is the script that I am using for this procedure
> > =====================================> > USE MASTER
> > GO
> > RESTORE FILELISTONLY
> > FROM DISK = '\\NAS1\NASDisk\SQL Server\SQL Server Production
> > Backup\Indii DB'
> > RESTORE LOG Indii
> > FROM DISK = '\\NAS1\NASDisk\SQL Server\SQL Server Production
> > Backup\Indii DB'
> > WITH MOVE 'Indii_Log' TO 'C:\Program Files\Microsoft SQL
> > Server\MSSQL$INDII_NY2_PROD\Data\Indii_Log.LDF'
> > -- WITH NORECOVERY
> > RESTORE DATABASE Indii
> > FROM DISK = '\\NAS1\NASDisk\SQL Server\SQL Server Production
> > Backup\Indii DB'
> > WITH NORECOVERY
> > =====================================> >
> > Here are the error(s) that I am receiving
> > =====================================> > Server: Msg 913, Level 16, State 8, Line 3
> > Could not find database ID 65535. Database may not be activated yet or
> > may be in transition.
> > Server: Msg 3013, Level 16, State 1, Line 3
> > RESTORE LOG is terminating abnormally.
> > Server: Msg 5105, Level 16, State 2, Line 7
> > Device activation error. The physical file name 'C:\Program
> > Files\Microsoft SQL Server\MSSQL$PRODUCTION\Data\\Indii_log.LDF' may be
> > incorrect.
> > Server: Msg 3156, Level 16, State 1, Line 7
> > File 'Indii_Log' cannot be restored to 'C:\Program Files\Microsoft SQL
> > Server\MSSQL$PRODUCTION\Data\\Indii_log.LDF'. Use WITH MOVE to identify
> > a valid location for the file.
> > Server: Msg 3013, Level 16, State 1, Line 7
> > RESTORE DATABASE is terminating abnormally.
> >
> It looks like you're trying to restore the log before the database has
> been restored. Restore the database first, THEN the log.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

Attempting to restore a db from a network drive and use the 'with move' statement

Attempting to restore a db from a network drive and need to move the
log file to a new location. CAN SOMEONE PLEAS REVIEW THE STATEMENTS
AND ERROR MESSAGES AND LET ME KNOW WHAT I AM DOING WRONG.
Here is the script that I am using for this procedure
=====================================
USE MASTER
GO
RESTORE FILELISTONLY
FROM DISK = '\\NAS1\NASDisk\SQL Server\SQL Server Production
Backup\Indii DB'
RESTORE LOG Indii
FROM DISK = '\\NAS1\NASDisk\SQL Server\SQL Server Production
Backup\Indii DB'
WITH MOVE 'Indii_Log' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL$INDII_NY2_PROD\Data\Indii_L
og.LDF'
-- WITH NORECOVERY
RESTORE DATABASE Indii
FROM DISK = '\\NAS1\NASDisk\SQL Server\SQL Server Production
Backup\Indii DB'
WITH NORECOVERY
=====================================
Here are the error(s) that I am receiving
=====================================
Server: Msg 913, Level 16, State 8, Line 3
Could not find database ID 65535. Database may not be activated yet or
may be in transition.
Server: Msg 3013, Level 16, State 1, Line 3
RESTORE LOG is terminating abnormally.
Server: Msg 5105, Level 16, State 2, Line 7
Device activation error. The physical file name 'C:\Program
Files\Microsoft SQL Server\MSSQL$PRODUCTION\Data\\Indii_log.LDF' may be
incorrect.
Server: Msg 3156, Level 16, State 1, Line 7
File 'Indii_Log' cannot be restored to 'C:\Program Files\Microsoft SQL
Server\MSSQL$PRODUCTION\Data\\Indii_log.LDF'. Use WITH MOVE to identify
a valid location for the file.
Server: Msg 3013, Level 16, State 1, Line 7
RESTORE DATABASE is terminating abnormally.Tracy,
The reason that I attempted to restore the log file first is because I
receive the same error either way.
Tracy McKibben wrote:
> war_wheelan@.yahoo.com wrote:
> It looks like you're trying to restore the log before the database has
> been restored. Restore the database first, THEN the log.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

attempt to copy 2005 db ouside my network shows wrong db?

I connected to an sql 2005 located out on the Internet.
I can export the database I have permissions for and its data ok.
When I right click on the db and choose copy, I get an error at the end of the
wizard saying that Database 'dbThatIsDifferentThanMine' cannot be opened because
it is offline. Error 942.
That database shows up in the managment console, and it is offline, but it is
not the one I right clicked on to copy. I don't have permission to put that
database online, just permissions for the one I want to copy.
How can I resolve this?
--
Thanks in advance, Les CaudleHi
I am not sure why this is not selecting your database when you right click!
Have you tried left clicking before you right click?
An althernative you be to backup and restore the database into a new copy,
you can do this in a query window. If you need to do this often then creating
a script will probably end up being quicker.
John
"Les Caudle" wrote:
> I connected to an sql 2005 located out on the Internet.
> I can export the database I have permissions for and its data ok.
> When I right click on the db and choose copy, I get an error at the end of the
> wizard saying that Database 'dbThatIsDifferentThanMine' cannot be opened because
> it is offline. Error 942.
> That database shows up in the managment console, and it is offline, but it is
> not the one I right clicked on to copy. I don't have permission to put that
> database online, just permissions for the one I want to copy.
> How can I resolve this?
> --
> Thanks in advance, Les Caudle
>|||John - Yes, I'd clicked on the database first. Very strange.
This is on a client's ISP's shared web server. I only have access to his
database - and am going to need to grab it.
Can I backup and restore in this circumstance - as you suggested? I think I'm
going to be limited in what I can do.
Thanks, Les Caudle
On Sun, 25 Jun 2006 00:00:02 -0700, John Bell <jbellnewsposts@.hotmail.com>
wrote:
>Hi
>I am not sure why this is not selecting your database when you right click!
>Have you tried left clicking before you right click?
>An althernative you be to backup and restore the database into a new copy,
>you can do this in a query window. If you need to do this often then creating
>a script will probably end up being quicker.
>John
>"Les Caudle" wrote:
>> I connected to an sql 2005 located out on the Internet.
>> I can export the database I have permissions for and its data ok.
>> When I right click on the db and choose copy, I get an error at the end of the
>> wizard saying that Database 'dbThatIsDifferentThanMine' cannot be opened because
>> it is offline. Error 942.
>> That database shows up in the managment console, and it is offline, but it is
>> not the one I right clicked on to copy. I don't have permission to put that
>> database online, just permissions for the one I want to copy.
>> How can I resolve this?
>> --
>> Thanks in advance, Les Caudle|||Les Caudle wrote:
> John - Yes, I'd clicked on the database first. Very strange.
> This is on a client's ISP's shared web server. I only have access to his
> database - and am going to need to grab it.
> Can I backup and restore in this circumstance - as you suggested? I think I'm
> going to be limited in what I can do.
>
Providing you can connect with Query Analyzer or Management Studio, and
have a directory that SQL can write to, you should be able to use the
BACKUP and RESTORE commands to do a backup and restore.|||Hi
To backup the datbase you will need in the db_backupoperator, db_owner or a
sysadmin role, for restoring you will need to be a sysadmin or in dbcreator
role.
To use sp_attach_db you will need CREATE DATABASE, CREATE ANY DATABASE, or
ALTER ANY DATABASE permission, for sp_detach_db you will need to be a
db_owner.
I suspect that the copy wizard may not be working because you fail on some
or all of these privileges. By doing a manual backup you may get a message
saying that you do not have the privileges to carry out the opertation.
John
"Les Caudle" wrote:
> John - Yes, I'd clicked on the database first. Very strange.
> This is on a client's ISP's shared web server. I only have access to his
> database - and am going to need to grab it.
> Can I backup and restore in this circumstance - as you suggested? I think I'm
> going to be limited in what I can do.
> Thanks, Les Caudle
>
> On Sun, 25 Jun 2006 00:00:02 -0700, John Bell <jbellnewsposts@.hotmail.com>
> wrote:
> >Hi
> >
> >I am not sure why this is not selecting your database when you right click!
> >Have you tried left clicking before you right click?
> >
> >An althernative you be to backup and restore the database into a new copy,
> >you can do this in a query window. If you need to do this often then creating
> >a script will probably end up being quicker.
> >
> >John
> >
> >"Les Caudle" wrote:
> >
> >> I connected to an sql 2005 located out on the Internet.
> >>
> >> I can export the database I have permissions for and its data ok.
> >>
> >> When I right click on the db and choose copy, I get an error at the end of the
> >> wizard saying that Database 'dbThatIsDifferentThanMine' cannot be opened because
> >> it is offline. Error 942.
> >>
> >> That database shows up in the managment console, and it is offline, but it is
> >> not the one I right clicked on to copy. I don't have permission to put that
> >> database online, just permissions for the one I want to copy.
> >>
> >> How can I resolve this?
> >> --
> >> Thanks in advance, Les Caudle
> >>
>

attempt to copy 2005 db ouside my network shows wrong db?

I connected to an sql 2005 located out on the Internet.
I can export the database I have permissions for and its data ok.
When I right click on the db and choose copy, I get an error at the end of
the
wizard saying that Database 'dbThatIsDifferentThanMine' cannot be opened bec
ause
it is offline. Error 942.
That database shows up in the managment console, and it is offline, but it i
s
not the one I right clicked on to copy. I don't have permission to put that
database online, just permissions for the one I want to copy.
How can I resolve this?
--
Thanks in advance, Les CaudleHi
I am not sure why this is not selecting your database when you right click!
Have you tried left clicking before you right click?
An althernative you be to backup and restore the database into a new copy,
you can do this in a query window. If you need to do this often then creatin
g
a script will probably end up being quicker.
John
"Les Caudle" wrote:

> I connected to an sql 2005 located out on the Internet.
> I can export the database I have permissions for and its data ok.
> When I right click on the db and choose copy, I get an error at the end o
f the
> wizard saying that Database 'dbThatIsDifferentThanMine' cannot be opened b
ecause
> it is offline. Error 942.
> That database shows up in the managment console, and it is offline, but it
is
> not the one I right clicked on to copy. I don't have permission to put th
at
> database online, just permissions for the one I want to copy.
> How can I resolve this?
> --
> Thanks in advance, Les Caudle
>|||Hi
I am not sure why this is not selecting your database when you right click!
Have you tried left clicking before you right click?
An althernative you be to backup and restore the database into a new copy,
you can do this in a query window. If you need to do this often then creatin
g
a script will probably end up being quicker.
John
"Les Caudle" wrote:

> I connected to an sql 2005 located out on the Internet.
> I can export the database I have permissions for and its data ok.
> When I right click on the db and choose copy, I get an error at the end o
f the
> wizard saying that Database 'dbThatIsDifferentThanMine' cannot be opened b
ecause
> it is offline. Error 942.
> That database shows up in the managment console, and it is offline, but it
is
> not the one I right clicked on to copy. I don't have permission to put th
at
> database online, just permissions for the one I want to copy.
> How can I resolve this?
> --
> Thanks in advance, Les Caudle
>|||John - Yes, I'd clicked on the database first. Very strange.
This is on a client's ISP's shared web server. I only have access to his
database - and am going to need to grab it.
Can I backup and restore in this circumstance - as you suggested? I think I
'm
going to be limited in what I can do.
Thanks, Les Caudle
On Sun, 25 Jun 2006 00:00:02 -0700, John Bell <jbellnewsposts@.hotmail.com>
wrote:
[vbcol=seagreen]
>Hi
>I am not sure why this is not selecting your database when you right click!
>Have you tried left clicking before you right click?
>An althernative you be to backup and restore the database into a new copy,
>you can do this in a query window. If you need to do this often then creati
ng
>a script will probably end up being quicker.
>John
>"Les Caudle" wrote:
>|||John - Yes, I'd clicked on the database first. Very strange.
This is on a client's ISP's shared web server. I only have access to his
database - and am going to need to grab it.
Can I backup and restore in this circumstance - as you suggested? I think I
'm
going to be limited in what I can do.
Thanks, Les Caudle
On Sun, 25 Jun 2006 00:00:02 -0700, John Bell <jbellnewsposts@.hotmail.com>
wrote:
[vbcol=seagreen]
>Hi
>I am not sure why this is not selecting your database when you right click!
>Have you tried left clicking before you right click?
>An althernative you be to backup and restore the database into a new copy,
>you can do this in a query window. If you need to do this often then creati
ng
>a script will probably end up being quicker.
>John
>"Les Caudle" wrote:
>|||Les Caudle wrote:
> John - Yes, I'd clicked on the database first. Very strange.
> This is on a client's ISP's shared web server. I only have access to his
> database - and am going to need to grab it.
> Can I backup and restore in this circumstance - as you suggested? I think
I'm
> going to be limited in what I can do.
>
Providing you can connect with Query Analyzer or Management Studio, and
have a directory that SQL can write to, you should be able to use the
BACKUP and RESTORE commands to do a backup and restore.|||Les Caudle wrote:
> John - Yes, I'd clicked on the database first. Very strange.
> This is on a client's ISP's shared web server. I only have access to his
> database - and am going to need to grab it.
> Can I backup and restore in this circumstance - as you suggested? I think
I'm
> going to be limited in what I can do.
>
Providing you can connect with Query Analyzer or Management Studio, and
have a directory that SQL can write to, you should be able to use the
BACKUP and RESTORE commands to do a backup and restore.|||Hi
To backup the datbase you will need in the db_backupoperator, db_owner or a
sysadmin role, for restoring you will need to be a sysadmin or in dbcreator
role.
To use sp_attach_db you will need CREATE DATABASE, CREATE ANY DATABASE, or
ALTER ANY DATABASE permission, for sp_detach_db you will need to be a
db_owner.
I suspect that the copy wizard may not be working because you fail on some
or all of these privileges. By doing a manual backup you may get a message
saying that you do not have the privileges to carry out the opertation.
John
"Les Caudle" wrote:

> John - Yes, I'd clicked on the database first. Very strange.
> This is on a client's ISP's shared web server. I only have access to his
> database - and am going to need to grab it.
> Can I backup and restore in this circumstance - as you suggested? I think
I'm
> going to be limited in what I can do.
> Thanks, Les Caudle
>
> On Sun, 25 Jun 2006 00:00:02 -0700, John Bell <jbellnewsposts@.hotmail.com>
> wrote:
>
>|||Hi
To backup the datbase you will need in the db_backupoperator, db_owner or a
sysadmin role, for restoring you will need to be a sysadmin or in dbcreator
role.
To use sp_attach_db you will need CREATE DATABASE, CREATE ANY DATABASE, or
ALTER ANY DATABASE permission, for sp_detach_db you will need to be a
db_owner.
I suspect that the copy wizard may not be working because you fail on some
or all of these privileges. By doing a manual backup you may get a message
saying that you do not have the privileges to carry out the opertation.
John
"Les Caudle" wrote:

> John - Yes, I'd clicked on the database first. Very strange.
> This is on a client's ISP's shared web server. I only have access to his
> database - and am going to need to grab it.
> Can I backup and restore in this circumstance - as you suggested? I think
I'm
> going to be limited in what I can do.
> Thanks, Les Caudle
>
> On Sun, 25 Jun 2006 00:00:02 -0700, John Bell <jbellnewsposts@.hotmail.com>
> wrote:
>
>

attaching database on create

Hi,

My current server going nuts it restaring every one hour, I have 200+GB (80+ files) database size. The network guyes don't have backup. This is what I am trying to do. I have detach my database. I have copied all the file to new server. Now i am trying to attach using create, I can't just use attach because 16+ files. When I run following on my server it gives me an error.

Any help will be highly appreciated.

please email me the answer if you have.

Thanks.

Samir

CREATE DATABASE KEYFILE
ON PRIMARY (NAME= 'KEYFILE001' FILENAME='F:\KEYFILEDB\KEYFILE001.MDF')
ON SECONDARY (NAME='KEYFILE002' FILENAME='F:\KEYFILEDB\KEYFILE002.NDF')
ON SECONDARY (NAME='KEYFILE003' FILENAME='F:\KEYFILEDB\KEYFILE003.NDF')
ON SECONDARY (NAME='KEYFILE004' FILENAME='F:\KEYFILEDB\KEYFILE004.NDF')
ON SECONDARY (NAME='KEYFILE005' FILENAME='F:\KEYFILEDB\KEYFILE005.NDF')
ON SECONDARY (NAME='KEYFILE006' FILENAME='F:\KEYFILEDB\KEYFILE006.NDF')
ON SECONDARY (NAME='KEYFILE007' FILENAME='F:\KEYFILEDB\KEYFILE007.NDF')
ON SECONDARY (NAME='KEYFILE008' FILENAME='F:\KEYFILEDB\KEYFILE008.NDF')
LOG ON SECONDARY (NAME= 'KEYFILE_LOG' FILENAME='F:\KEYFILEDB\KEYFILE_LOG.LDF')

FOR ATTACHWhat's the error message that you are getting?

A superfluous comment would be that 80+ files seems a bit much. Is there not some way for you to decrease the number of files (moving objects, etc)?

Regards,

hmscott

Attaching a DB to a Network Folder

I'm trying to attach a db to a network folder.

I used the sproc sp_attach_db from master db to attach a test db to a local drive (c:\test) and works fine.

EXEC sp_attach_db @.dbname = N'myDatabase',
@.filename1 = N'C:\Test\myDatabase.mdf'

NO PROB. With this--

but when i try to attach a test td to a network drive, (\\computer\test) does not work.

EXEC sp_attach_db @.dbname = N'myDatabase',
@.filename1 = N'\\computer\test\myDatabase.mdf'

--I get this error message -

File '\\computer\test\myDatabase.mdf' is on a network device not supported for database files.

So i'm thinking that I can not use sp_attach_db sproc to attach a db to a network drive?

Is there any other way to attach a db to a network drive?

I even tried to map the network folder and it did not work.

EXEC sp_attach_db @.dbname = N'myDatabase',
@.filename1 = N'z:\test\myDatabase.mdf'

Yeah i forgot to tell you I'm using SQL Server 2000.
If you have ever run into this kind of situation, please let me know.

Thanks.

Irv

This link may help

http://support.microsoft.com/default.aspx?scid=kb;en-us;304261

specifically the use of trace flag 1807

|||You could try adding trace flag 1807
Allows you to configure SQL Server with network-based database files.

Note: I would not do this with a database myself because I don't know the down side.

See thread http://forums.databasejournal.com/showthread.php?t=30580&goto=nextnewest

Tim S

|||

Thanks Guys, That was really helpful!

Irv