Database state loading after restore.

Hi,
I have sql server 2000 running on windows 2003 clusters. While i
tried to restore the database i got the message that The restore
operation was successful. But still the database is showing state
"Loading."
I restored the database with recovery (Leave database opeational in
EM). I kept the database for a day and it shows still status as
"Loading".
Any help for this is highly appreciated.
Regards,
Jay
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Are you sure it is not only a refers issue in EM? Did you try below:
RESTORE DATABASE dbname WITH RECOVERY
And if you try above, what messages do you get?
Also, if you open QA and say "USE dbname", any errors?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Jigar Patel" <jigar_pcs@.rediffmail.com> wrote in message
news:uCLjUt4rDHA.2828@.tk2msftngp13.phx.gbl...
> Hi,
> I have sql server 2000 running on windows 2003 clusters. While i
> tried to restore the database i got the message that The restore
> operation was successful. But still the database is showing state
> "Loading."
> I restored the database with recovery (Leave database opeational in
> EM). I kept the database for a day and it shows still status as
> "Loading".
> Any help for this is highly appreciated.
> Regards,
> Jay
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||I am sure as i have done this operation for atleast 15 times as of now.
I tried everything.
When i try to use
Use Database
Go
The message comes saying the database is still loading is not available.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||So what errors/messages do you get from the below command?
RESTORE DATABASE dbname WITH RECOVERY
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Jigar Patel" <jigar_pcs@.rediffmail.com> wrote in message
news:uovOaN7rDHA.2360@.TK2MSFTNGP09.phx.gbl...
> I am sure as i have done this operation for atleast 15 times as of now.
> I tried everything.
> When i try to use
> Use Database
> Go
> The message comes saying the database is still loading is not available.
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Database Service Won't Start

We have multiple instances at Windows 2000 Advanced Server. One default
database is Enterprise Edition and another two instances are Developer
Editions. They have been running fine until recently.
We can start ANY ONE instance from the EM, only ONE. None of any other
services can be started anymore. Not even SQL Agent. We have to start
rest of other database services and sql agent from command line.
When we try to connect the SQL Server or Agent from the EM, we got
"Error 1053 - (The service did not respond to the start or control
request in a timely fashion) occured while performing this service
operation on the MSSQL service."
Thought maybe some corrpution to currnet databases, DLL etc. Installed
another new instance on the server, got the same error message.
Verified Microsoft KB article 322140, does not seem apply to us.
Any opinion is appreciated.Hi,
What you could do is first backup all the databases currently running on your
server.
1) Please never install Enterprise Edition and Developer Edition on the Same
Drive.
2) Install both of them on separate Drives.
3) Setup the Client and Server Tools for only the Enterprise Edition.
4) And when installing the Developer Editions, install only the Server and
not the client tools.
I faced a similar problem when I installed SQL Server 2000 and SQL server
2005 express on the same drive.
So when I installed it on separate drives, no problems faced yet :)
Hope this helps :)
--
Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.db2india.org
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200609/1|||Thanks for your response.
But it works fine before, until 2 weeks ago. Now I can start them from
command line.
Thanks.
DB2DOTNETCZAR via SQLMonster.com wrote:
> Hi,
> What you could do is first backup all the databases currently running on your
> server.
> 1) Please never install Enterprise Edition and Developer Edition on the Same
> Drive.
> 2) Install both of them on separate Drives.
> 3) Setup the Client and Server Tools for only the Enterprise Edition.
> 4) And when installing the Developer Editions, install only the Server and
> not the client tools.
> I faced a similar problem when I installed SQL Server 2000 and SQL server
> 2005 express on the same drive.
> So when I installed it on separate drives, no problems faced yet :)
> Hope this helps :)
> --
> Best Regards
> Anil Mahadev
> http://anilm001.myfreewebs.net/index2.php
> http://www.db2india.org
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200609/1

Database Service Won't Start

We have multiple instances at Windows 2000 Advanced Server. One default
database is Enterprise Edition and another two instances are Developer
Editions. They have been running fine until recently.
We can start ANY ONE instance from the EM, only ONE. None of any other
services can be started anymore. Not even SQL Agent. We have to start
rest of other database services and sql agent from command line.
When we try to connect the SQL Server or Agent from the EM, we got
"Error 1053 - (The service did not respond to the start or control
request in a timely fashion) occured while performing this service
operation on the MSSQL service."
Thought maybe some corrpution to currnet databases, DLL etc. Installed
another new instance on the server, got the same error message.
Verified Microsoft KB article 322140, does not seem apply to us.
Any opinion is appreciated.Hi,
What you could do is first backup all the databases currently running on you
r
server.
1) Please never install Enterprise Edition and Developer Edition on the Same
Drive.
2) Install both of them on separate Drives.
3) Setup the Client and Server Tools for only the Enterprise Edition.
4) And when installing the Developer Editions, install only the Server and
not the client tools.
I faced a similar problem when I installed SQL Server 2000 and SQL server
2005 express on the same drive.
So when I installed it on separate drives, no problems faced yet
Hope this helps
Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.db2india.org
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1|||Thanks for your response.
But it works fine before, until 2 weeks ago. Now I can start them from
command line.
Thanks.
DB2DOTNETCZAR via droptable.com wrote:
> Hi,
> What you could do is first backup all the databases currently running on y
our
> server.
> 1) Please never install Enterprise Edition and Developer Edition on the Sa
me
> Drive.
> 2) Install both of them on separate Drives.
> 3) Setup the Client and Server Tools for only the Enterprise Edition.
> 4) And when installing the Developer Editions, install only the Server and
> not the client tools.
> I faced a similar problem when I installed SQL Server 2000 and SQL server
> 2005 express on the same drive.
> So when I installed it on separate drives, no problems faced yet
> Hope this helps
> --
> Best Regards
> Anil Mahadev
> http://anilm001.myfreewebs.net/index2.php
> http://www.db2india.org
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200609/1

Database Service Won't Start

We have multiple instances at Windows 2000 Advanced Server. One default
database is Enterprise Edition and another two instances are Developer
Editions. They have been running fine until recently.
We can start ANY ONE instance from the EM, only ONE. None of any other
services can be started anymore. Not even SQL Agent. We have to start
rest of other database services and sql agent from command line.
When we try to connect the SQL Server or Agent from the EM, we got
"Error 1053 - (The service did not respond to the start or control
request in a timely fashion) occured while performing this service
operation on the MSSQL service."
Thought maybe some corrpution to currnet databases, DLL etc. Installed
another new instance on the server, got the same error message.
Verified Microsoft KB article 322140, does not seem apply to us.
Any opinion is appreciated.
Hi,
What you could do is first backup all the databases currently running on your
server.
1) Please never install Enterprise Edition and Developer Edition on the Same
Drive.
2) Install both of them on separate Drives.
3) Setup the Client and Server Tools for only the Enterprise Edition.
4) And when installing the Developer Editions, install only the Server and
not the client tools.
I faced a similar problem when I installed SQL Server 2000 and SQL server
2005 express on the same drive.
So when I installed it on separate drives, no problems faced yet
Hope this helps
Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.db2india.org
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200609/1
|||Thanks for your response.
But it works fine before, until 2 weeks ago. Now I can start them from
command line.
Thanks.
DB2DOTNETCZAR via droptable.com wrote:
> Hi,
> What you could do is first backup all the databases currently running on your
> server.
> 1) Please never install Enterprise Edition and Developer Edition on the Same
> Drive.
> 2) Install both of them on separate Drives.
> 3) Setup the Client and Server Tools for only the Enterprise Edition.
> 4) And when installing the Developer Editions, install only the Server and
> not the client tools.
> I faced a similar problem when I installed SQL Server 2000 and SQL server
> 2005 express on the same drive.
> So when I installed it on separate drives, no problems faced yet
> Hope this helps
> --
> Best Regards
> Anil Mahadev
> http://anilm001.myfreewebs.net/index2.php
> http://www.db2india.org
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200609/1

Database restore problem

A customer's Windows 2000 server would not reboot. They
ran a repair, but the drive letters on the server moved
ahead two spots. The drive letter D is now drive F.
I attempted a restore of a database through Enterprise
Manager, but I get the following error message :
"Device activation error: the physical file name d:\sql
db\otg.mdf: may be incorrect. File 'otg data' cannot be
restored to d:\sql db\otg.mdf'. Use with move to identify
a valid location for the file. Device activation error.
The physical file name 'D:\sql db\otglog.ldf may be
incorrect. File 'otglog' cannot be restored to 'd:\sql
db\otglog.ldf.' Use with move to identify a valid location
for the file. Restore db is terminating abnormally."
The original database files were located on C. A backup of
the database was saved to D.
What can I do to restore this database? Can anyone suggest
a query that restores the database to its previous state?
Thanks for your help.Hello Craig !
If you restore in EM you should change the path where you want to place the
new datafiles from the backup.
Please note, that the directories will NOT be created by EM, they must be
created before restoring the database.
HTH, Jens Süßmeyer.|||Try this:
RESTORE DATABASE otg
FROM DISK= 'c:\wherever the .bak file is'
WITH RECOVERY,replace,
MOVE 'otg_data' TO 'd:\sql_db\otg.mdf',
MOVE 'otgLog' TO 'd:\sql_db\otglog.ldf.'
Make sure you have enough permissions, with OTG imaging database you can use
the sysop user ;)
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Craig Kornacki" <ckornack@.localnet.com> wrote in message
news:034701c36f5b$2e13c320$a301280a@.phx.gbl...
> A customer's Windows 2000 server would not reboot. They
> ran a repair, but the drive letters on the server moved
> ahead two spots. The drive letter D is now drive F.
> I attempted a restore of a database through Enterprise
> Manager, but I get the following error message :
> "Device activation error: the physical file name d:\sql
> db\otg.mdf: may be incorrect. File 'otg data' cannot be
> restored to d:\sql db\otg.mdf'. Use with move to identify
> a valid location for the file. Device activation error.
> The physical file name 'D:\sql db\otglog.ldf may be
> incorrect. File 'otglog' cannot be restored to 'd:\sql
> db\otglog.ldf.' Use with move to identify a valid location
> for the file. Restore db is terminating abnormally."
> The original database files were located on C. A backup of
> the database was saved to D.
> What can I do to restore this database? Can anyone suggest
> a query that restores the database to its previous state?
> Thanks for your help.|||I know it's late, but what I would do is change the Drive letter to the
original drive letter using windows disk manager... This will likely prevent
other mapping kinds of errors from other applications as well.
"Craig Kornacki" <ckornack@.localnet.com> wrote in message
news:034701c36f5b$2e13c320$a301280a@.phx.gbl...
> A customer's Windows 2000 server would not reboot. They
> ran a repair, but the drive letters on the server moved
> ahead two spots. The drive letter D is now drive F.
> I attempted a restore of a database through Enterprise
> Manager, but I get the following error message :
> "Device activation error: the physical file name d:\sql
> db\otg.mdf: may be incorrect. File 'otg data' cannot be
> restored to d:\sql db\otg.mdf'. Use with move to identify
> a valid location for the file. Device activation error.
> The physical file name 'D:\sql db\otglog.ldf may be
> incorrect. File 'otglog' cannot be restored to 'd:\sql
> db\otglog.ldf.' Use with move to identify a valid location
> for the file. Restore db is terminating abnormally."
> The original database files were located on C. A backup of
> the database was saved to D.
> What can I do to restore this database? Can anyone suggest
> a query that restores the database to its previous state?
> Thanks for your help.|||Will this query work even if there is no D drive on the
server?
>--Original Message--
>Try this:
>RESTORE DATABASE otg
>FROM DISK= 'c:\wherever the .bak file is'
> WITH RECOVERY,replace,
> MOVE 'otg_data' TO 'd:\sql_db\otg.mdf',
> MOVE 'otgLog' TO 'd:\sql_db\otglog.ldf.'
>Make sure you have enough permissions, with OTG imaging
database you can use
>the sysop user ;)
>HTH
>--
>Ray Higdon MCSE, MCDBA, CCNA
>--
>"Craig Kornacki" <ckornack@.localnet.com> wrote in message
>news:034701c36f5b$2e13c320$a301280a@.phx.gbl...
>> A customer's Windows 2000 server would not reboot.
They
>> ran a repair, but the drive letters on the server moved
>> ahead two spots. The drive letter D is now drive F.
>> I attempted a restore of a database through Enterprise
>> Manager, but I get the following error message :
>> "Device activation error: the physical file name
d:\sql
>> db\otg.mdf: may be incorrect. File 'otg data' cannot
be
>> restored to d:\sql db\otg.mdf'. Use with move to
identify
>> a valid location for the file. Device activation
error.
>> The physical file name 'D:\sql db\otglog.ldf may be
>> incorrect. File 'otglog' cannot be restored to 'd:\sql
>> db\otglog.ldf.' Use with move to identify a valid
location
>> for the file. Restore db is terminating abnormally."
>> The original database files were located on C. A
backup of
>> the database was saved to D.
>> What can I do to restore this database? Can anyone
suggest
>> a query that restores the database to its previous
state?
>> Thanks for your help.
>
>.
>

Database Restore

I have a SQL cluster I built about two weeks ago on Windows 2003, now we are
trying to restore a database to the server from a different location (non
cluster) and we are unable, database seems to go but sql manager states the
database is in a still loading state, is there anything I have to do, like
stop the cluster services.
Thanks,
Bob Smith
Hi
Make sure that you select "Leave database oprational..." from the options
tab in the Restore dialogue.
You can re-run the restore, overwriting the DB you tried earlier.
Regards
Mike
"Bob Smith" wrote:

> I have a SQL cluster I built about two weeks ago on Windows 2003, now we are
> trying to restore a database to the server from a different location (non
> cluster) and we are unable, database seems to go but sql manager states the
> database is in a still loading state, is there anything I have to do, like
> stop the cluster services.
> Thanks,
> Bob Smith
|||Mike,
Thanks, but this was checked, do I need to break the cluster to do a
restore, I even tried creating new database and doing an import, btw I am not
a very experienced sql admin, I know my way around and can troubleshoot etc,
but I done the restore on a straight sql server non cluster, then I go to the
clustered setup and do the restore and it sits there saying loading and it is
grayed out.
Thanks Again,
Bob Smith
"Bob Smith" wrote:

> I have a SQL cluster I built about two weeks ago on Windows 2003, now we are
> trying to restore a database to the server from a different location (non
> cluster) and we are unable, database seems to go but sql manager states the
> database is in a still loading state, is there anything I have to do, like
> stop the cluster services.
> Thanks,
> Bob Smith
|||See if this helps.
Copy the data and log files for your user database from the non-clustered server to the shared disk that your SQL Server virtual instance recognizes.
Lets say for example, you copied the mydbdata.mdf and mydbdata.ldf files to "F:\Program Files\Microsoft SQL Server\MSSQL\Data" folder
Now re-attach the database pointing to the files in the new location as follows: (Run the following commands from Query Analyzer)
use master
go
sp_attach_db 'mydb','C:\Program Files\Microsoft SQL Server\MSSQL\Data\mydbdata.mdf','C:\Program Files\Microsoft SQL Server\MSSQL\Data\mydblog.ldf'
go
Verify the change in file locations using sp_helpfile :
use mydb
go
sp_helpfile
go
If you are not comforable with Query Analyzer, you can use Enterprise Manager to attach the db. Here are the steps from SQL Server Books Online
To attach a database
Expand a server group, and then expand a server.
Right-click Databases, and select All Tasks/Attach Database.
Enter the name of the MDF (master data file) of the database to attach. If you are not sure where the file is located, click browse (...) to search. There can only be up to 16 file names specified. For more information,
see sp_attach_db.
To ensure that the specified MDF file is correct, click Verify. The Original File Name(s) column lists all the files in the database (data files and log files). The Current File(s) Location column lists the file names and
paths. If Microsoft SQL Server cannot find the files in the specified locations, the attach operation fails. The Current File(s) Location column can be edited, and the current location of the file must be in this column for
the attach operation to work. For example, if you have changed the default location of the file before you detached it, you must specify the current location for the attach operation to be successful.
In the Attach as box, enter the name of the database. The database name must not match any existing database names.
Specify the database owner.
Click OK. A database node for the newly attached database is created in the Database folder.
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Database Recovery Problem

Greetings,
I am attempting to restore some databases to a SQL Server
2000 Installation that fell apart after loading SP4 for
Windows 2000. The backups were made using Veritas Backup
Exec 8.6. on a remote backup server. When I do a restore
on my databases Veritas restores all of them to the the
SQL Server and they appear in Enterprise Manager. However
the databases are in a state of loading and I cannot seem
to find a way to take them out of this loading state to
complete the restore to normal operation.
I am new to SQL Server so I am at a loss as to what to do
to rectify this situation.
Thanks in advance for the help.
Joe.If you have restored the databases with norecovery you can
restore database mydb with recovery
to bring it on-line.
If in fact veritas hasn't completed the restore then you
will have to go back to that product.
>"Joe Toth" <jtoth@.cmefcu.org> wrote in message
>news:029d01c34727$da60cee0$a401280a@.phx.gbl...
>> Greetings,
>> I am attempting to restore some databases to a SQL
Server
>> 2000 Installation that fell apart after loading SP4 for
>> Windows 2000. The backups were made using Veritas Backup
>> Exec 8.6. on a remote backup server. When I do a restore
>> on my databases Veritas restores all of them to the the
>> SQL Server and they appear in Enterprise Manager.
However
>> the databases are in a state of loading and I cannot
seem
>> to find a way to take them out of this loading state to
>> complete the restore to normal operation.
>> I am new to SQL Server so I am at a loss as to what to
do
>> to rectify this situation.
>> Thanks in advance for the help.
>> Joe.
>
>.
>|||It's been a few months since I restored from BE, but I
think it's an option when configuring the restore on the
SQL tab. The db is left in this state so you can apply
logs if you need to.
--Scott
>--Original Message--
>Greetings,
>I am attempting to restore some databases to a SQL Server
>2000 Installation that fell apart after loading SP4 for
>Windows 2000. The backups were made using Veritas Backup
>Exec 8.6. on a remote backup server. When I do a restore
>on my databases Veritas restores all of them to the the
>SQL Server and they appear in Enterprise Manager. However
>the databases are in a state of loading and I cannot seem
>to find a way to take them out of this loading state to
>complete the restore to normal operation.
>I am new to SQL Server so I am at a loss as to what to do
>to rectify this situation.
>Thanks in advance for the help.
>Joe.
>.
>

Database recovery freezing server?

I'm currently running Windows Server 2003 and just recently installed SQL 2005. I had a few databases that I was attaching from the old SQL 2000 server. I encountered a hard error and when I restarted Management studio, I found 4 of my databases were in recovery. Thinking this would be a short process, I let it run and did work on one of my other machines. Nearly 2 hours later, the databases are still in recovery and nothing appears to have changed. I'm new to sql 2005 and don't know what the best method of bringing those databases back up would be. If it is possible to just detach the databases (or blow them away completely) I have backups that are plenty recent enough, however I find I am unable to make any changes to the databases while one of the system db's is in recovery. Any ideas?

KCanterucci,

I think you can find more accurate answer in sql server engine forum.

Database permission error

Windows Pro
Receiving the following error:
CREATE DATABASE permission denied in database 'master'. Could not attach
database 'pubs' to file 'D:\Program Files\Microsoft SQL
Server\MSSQL$NETSDK\Data\pubs.mdf'.
Here are some things done to try to resolve the problem:
Reboot 4-5 times
Shared out the folder
Web shared the folder
Thanks for your help,
T.Are you connecting with a trusted connection or as sa. It sounds like you
do not have the access required to create a database. Make sure you are
connecting in as a member of the Administrators group on that machine so you
become part of the sysadmin (aka System Administrators) role. At a minimum
you need the dbcreator role level access. Running
sp_helpsrvrolemember 'sysadmin'
-- or --
sp_helpsrvrolemember 'dbcreator'
will tell you who belongs to these roles. Looking at the Query window title
bar will tell you who you are logged in as.
<servername>.<database name>.<loginname> or <DOMAIN>\<username> (for Win NT
authentication)
Reboot and sharing the folder will not help. You might want to check the NT
permissions though.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Taishi" <taishi_bak@.hotmail.com> wrote in message
news:%23ZocZIy6DHA.2568@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Windows Pro
> Receiving the following error:
> CREATE DATABASE permission denied in database 'master'. Could not attach
> database 'pubs' to file 'D:\Program Files\Microsoft SQL
> Server\MSSQL$NETSDK\Data\pubs.mdf'.
> Here are some things done to try to resolve the problem:
> Reboot 4-5 times
> Shared out the folder
> Web shared the folder
>
> Thanks for your help,
> T.
>
>

---

|||Andy,
I am new to SQL. It was hard just to figure out how to install it.
I know I am logged in as a Admin. in Windows.
I have the little server box with the round circle on it in the bottom right
corner(toolbar). The SQL Server Service Manager.
I tried to search for the sp_helpsrvrolemember command on my drive. It's
not on the server.
Any ideas?
Thanks for your help,
T
"Andy Svendsen" <andymcdba1@.NOMORESPAM.yahoo.com> wrote in message
news:#3883ky6DHA.2628@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Are you connecting with a trusted connection or as sa. It sounds like you
> do not have the access required to create a database. Make sure you are
> connecting in as a member of the Administrators group on that machine so

---

you

quote:

---

> become part of the sysadmin (aka System Administrators) role. At a

---

minimum

quote:

---

> you need the dbcreator role level access. Running
> sp_helpsrvrolemember 'sysadmin'
> -- or --
> sp_helpsrvrolemember 'dbcreator'
> will tell you who belongs to these roles. Looking at the Query window

---

title

quote:

---

> bar will tell you who you are logged in as.
> <servername>.<database name>.<loginname> or <DOMAIN>\<username> (for Win

---

NT

quote:

---

> authentication)
>
> Reboot and sharing the folder will not help. You might want to check the

---

NT

quote:

---

> permissions though.
> --
> ****************************************
***************************
> Andy S.
> MCSE NT/2000, MCDBA SQL 7/2000
> andymcdba1@.NOMORESPAM.yahoo.com
> Please remove NOMORESPAM before replying.
> Always keep your antivirus and Microsoft software
> up to date with the latest definitions and product updates.
> Be suspicious of every email attachment, I will never send
> or post anything other than the text of a http:// link nor
> post the link directly to a file for downloading.
> This posting is provided "as is" with no warranties
> and confers no rights.
> ****************************************
***************************
> "Taishi" <taishi_bak@.hotmail.com> wrote in message
> news:%23ZocZIy6DHA.2568@.TK2MSFTNGP10.phx.gbl...
>

---

Database permission error

Andy,

I am new to SQL. It was hard just to figure out how to install it.

I know I am logged in as a Admin. in Windows.

I have the little server box with the round circle on it in the bottom right
corner(toolbar). The SQL Server Service Manager.

I tried to search for the sp_helpsrvrolemember command on my drive. It's
not on the server.

Any ideas?

Do anyone have any suggestions?

Thanks for your help,
T

"Andy Svendsen" <andymcdba1@.NOMORESPAM.yahoo.com> wrote in message
news:#3883ky6DHA.2628@.TK2MSFTNGP10.phx.gbl...
> Are you connecting with a trusted connection or as sa. It sounds like you
> do not have the access required to create a database. Make sure you are
> connecting in as a member of the Administrators group on that machine so
you
> become part of the sysadmin (aka System Administrators) role. At a
minimum
> you need the dbcreator role level access. Running
> sp_helpsrvrolemember 'sysadmin'
> -- or --
> sp_helpsrvrolemember 'dbcreator'
> will tell you who belongs to these roles. Looking at the Query window
title
> bar will tell you who you are logged in as.
> <servername>.<database name>.<loginname> or <DOMAIN>\<username> (for Win
NT
> authentication)
>
> Reboot and sharing the folder will not help. You might want to check the
NT
> permissions though.
> --
> ************************************************** *****************
> Andy S.
> MCSE NT/2000, MCDBA SQL 7/2000
> andymcdba1@.NOMORESPAM.yahoo.com
> Please remove NOMORESPAM before replying.
> Always keep your antivirus and Microsoft software
> up to date with the latest definitions and product updates.
> Be suspicious of every email attachment, I will never send
> or post anything other than the text of a http:// link nor
> post the link directly to a file for downloading.
> This posting is provided "as is" with no warranties
> and confers no rights.
> ************************************************** *****************
> "Taishi" <taishi_bak@.hotmail.com> wrote in message
> news:%23ZocZIy6DHA.2568@.TK2MSFTNGP10.phx.gbl...
> > Windows Pro
> > Receiving the following error:
> > CREATE DATABASE permission denied in database 'master'. Could not attach
> > database 'pubs' to file 'D:\Program Files\Microsoft SQL
> > Server\MSSQL$NETSDK\Data\pubs.mdf'.
> > Here are some things done to try to resolve the problem:
> > Reboot 4-5 times
> > Shared out the folder
> > Web shared the folder
> > Thanks for your help,
> > T.Taishi (taishi_bak@.hotmail.com) writes:
> I tried to search for the sp_helpsrvrolemember command on my drive. It's
> not on the server.

Searching the drive? There you will not find it. This is not a command
you run Explorer or the Command-Line Window.

This is a command that you run in Query Analyzer that comes with SQL Server.
From Query Analyzer you can pass any T-SQL command to SQL Server and
ser the result from it.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||I am using WIN XP Pro and the SQL is the MSDE.

How can I check my access?

How can I resolve the following error?

CREATE DATABASE permission denied in database 'master'. Could not attach
database 'pubs' to file 'D:\Program Files\Microsoft SQL
Server\MSSQL$NETSDK\Data\pubs.mdf'.

Thanks,
T.

"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns9486F27E141C6Yazorman@.127.0.0.1...
> Taishi (taishi_bak@.hotmail.com) writes:
> > I tried to search for the sp_helpsrvrolemember command on my drive.
It's
> > not on the server.
> Searching the drive? There you will not find it. This is not a command
> you run Explorer or the Command-Line Window.
> This is a command that you run in Query Analyzer that comes with SQL
Server.
> From Query Analyzer you can pass any T-SQL command to SQL Server and
> ser the result from it.
>
> --
> Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||Taishi (taishi_bak@.hotmail.com) writes:
> I am using WIN XP Pro and the SQL is the MSDE.
> How can I check my access?
> How can I resolve the following error?
> CREATE DATABASE permission denied in database 'master'. Could not attach
> database 'pubs' to file 'D:\Program Files\Microsoft SQL
> Server\MSSQL$NETSDK\Data\pubs.mdf'.

Exactly what command did you run?

How did you log into SQL Server?

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||I haven't ran any commands. I just installed it and tried to access the
dbase from a web form. The error is in my first post. I installed the MSDE
2000 from the following web site:

ww.microsoft.com/downloads

Featured download
Microsoft SQL Server 2000
Desktop Engine(MSDE 2000) Release A

I don't have the SQL server disks.

Any ideas? What commands can I use to check access rights?

Thanks,
T.

"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns948811073404Yazorman@.127.0.0.1...
> Taishi (taishi_bak@.hotmail.com) writes:
> > I am using WIN XP Pro and the SQL is the MSDE.
> > How can I check my access?
> > How can I resolve the following error?
> > CREATE DATABASE permission denied in database 'master'. Could not attach
> > database 'pubs' to file 'D:\Program Files\Microsoft SQL
> > Server\MSSQL$NETSDK\Data\pubs.mdf'.
> Exactly what command did you run?
> How did you log into SQL Server?
> --
> Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||Taishi (taishi_bak@.hotmail.com) writes:
> I haven't ran any commands. I just installed it and tried to access the
> dbase from a web form. The error is in my first post. I installed the
> MSDE 2000 from the following web site:
> ww.microsoft.com/downloads
> Featured download
> Microsoft SQL Server 2000
> Desktop Engine(MSDE 2000) Release A
> I don't have the SQL server disks.
> Any ideas? What commands can I use to check access rights?

Obviously then that web form tried run some commands. Exactly where
did this web form come from? Did you write it yourself, or was it included
in the download?

Is the web server on the same machine as MSDE? And what rights does the
account that web server is logged in have?

I would assume that the web form logs into MSDE with Windows authentication,
but it does not have sysadmin privileges. If you give the web-server account
administrator privileges in Windows, things might go better. You may have to
restart the web server for the change to have effect.
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||
"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns948A6458FF29BYazorman@.127.0.0.1...
> Taishi (taishi_bak@.hotmail.com) writes:
> > I haven't ran any commands. I just installed it and tried to access the
> > dbase from a web form. The error is in my first post. I installed the
> > MSDE 2000 from the following web site:
> > ww.microsoft.com/downloads
> > Featured download
> > Microsoft SQL Server 2000
> > Desktop Engine(MSDE 2000) Release A
> > I don't have the SQL server disks.
> > Any ideas? What commands can I use to check access rights?
> Obviously then that web form tried run some commands. Exactly where
> did this web form come from? Did you write it yourself, or was it included
> in the download?
> Is the web server on the same machine as MSDE? And what rights does the
> account that web server is logged in have?
> I would assume that the web form logs into MSDE with Windows
authentication,
> but it does not have sysadmin privileges. If you give the web-server
account
> administrator privileges in Windows, things might go better. You may have
to
> restart the web server for the change to have effect.
> --
> Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp

I wrote the Web form myself. Everything is on the same machine.

I have to figure out your question about the Web Server account.

I am using IIS and ASP. (i feel dumb)

Is IIS my web server?

Thanks for help,
T.|||Taishi (taishi_bak@.hotmail.com) writes:
> I wrote the Web form myself. Everything is on the same machine.

Ah, but if you wrote the web form, you also included commands for
SQL Server one way or another.

> I have to figure out your question about the Web Server account.
> I am using IIS and ASP. (i feel dumb)
> Is IIS my web server?

I don't know much about IIS (or ASP), but I believe it is a web server.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland,

Do you know how to use Enterprise Manager?

I was able to find a trial version of the Enterprise Manager.

After reading my error today, I can see there is a problem with 2 dbases
'PUBS' and 'Master'

CREATE DATABASE permission denied in database 'master'. Could not attach
database 'pubs' to file 'D:\Program Files\Microsoft SQL
Server\MSSQL$NETSDK\Data\pubs.mdf'.

I can see the following in the MSDE manager:

sql server(my machine name\??SDK)
after I right click on 'PUBS' the following pops up.
--Users/Roles/Public
--public
--machine_name\aspnet
--guest

guest is the only one with 5 check marks going across from left to right for
the following:
Create Table, Create View, Create SP, Create Default, Create Rule

the following 3 are blank:
Create Function, Backup DB, and Backup Log

public has just 1 check mark on
Create SP

machine_name\aspnet is blank from left to right.

CREATE DBASE right is not displayed.

How can I solve my Permission denied error problem?

Thanks for the help,
Taishi

"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns948AEF077388EYazorman@.127.0.0.1...
> Taishi (taishi_bak@.hotmail.com) writes:
> > I wrote the Web form myself. Everything is on the same machine.
> Ah, but if you wrote the web form, you also included commands for
> SQL Server one way or another.
> > I have to figure out your question about the Web Server account.
> > I am using IIS and ASP. (i feel dumb)
> > Is IIS my web server?
> I don't know much about IIS (or ASP), but I believe it is a web server.
> --
> Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||Taishi (taishi_bak@.hotmail.com) writes:
> Do you know how to use Enterprise Manager?

Barely. :-) I prefer to carry most of my task by submitting T-SQL
commands from Enterprise Manager.

> I was able to find a trial version of the Enterprise Manager.
> After reading my error today, I can see there is a problem with 2 dbases
> 'PUBS' and 'Master'
> CREATE DATABASE permission denied in database 'master'. Could not attach
> database 'pubs' to file 'D:\Program Files\Microsoft SQL
> Server\MSSQL$NETSDK\Data\pubs.mdf'.

But you still have not told us what that web form is doing! Sorry, I
cannot give much precise help if you don't explain what you are trying
to do.

But for the record, master and pubs are both databases that comes with
SQL Server, but they are very different. pubs is a regular user database,
and is there for demonstration and training purposes. master on the
other hand, is, as the name, indicates the master database. In this
database, SQL Server stores all server-wide information, for instance
which databases there are.

So the permission error applies to the master database, not to pubs.
I can't tell why you get this error, because I don't know what you
are doing (and you refuse to tell me). But since pubs already exist,
you cannot attach it anyway.

Anyway, what I tried to tell you last time, is that the web server
needs to connect to SQL Server with sysadmin privileges to create
databases, and to do that it must either log in as "sa" using SQL
Server authentication, or log using Windows authentication with an
account that has Administrator rights in Windows, or which have been
added to the sysadmin role in SQL Server.

So the rights you should are those that the IIS account has.
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland,

The web form is using a listbox to list items from SQL.

Here is my code:

Dim drStores As SqlClient.SqlDataReader

If Not IsPostBack Then

conPubs.Open()

drStores = cmdStores.ExecuteReader()

ddlStores.DataSource = drStores

ddlStores.DataTextField = "stor_name"

ddlStores.DataBind()

drStores.Close()

conPubs.Close()

End If

I didn't close my conPubs()-->MyConnection. That's one reason why I was
receiving the error before. But now my problem is that the ListBox is not
populating. The form just has a box that is empty. Seems simple for an
experienced programmer but I'm not at the level, yet.

In the Properties for MyConnection I have the following as my Connection
String:

workstation id=MyMachineName;packet size=4096;integrated security=SSPI;data
source="MyMachineName\vsdotnet";attachdbfilename="D:\Program Files\Microsoft
SQL Server\MSSQL$NETSDK\Data\pubs.mdf";persist security info=False;initial
catalog=pubs

In the Properties for MyCommand I have the following as my Connection
String:

workstation id=MyMachineName;packet size=4096;integrated security=SSPI;data
source="MyMachineName\vsdotnet";attachdbfilename="D:\Program Files\Microsoft
SQL Server\MSSQL$NETSDK\Data\pubs.mdf";persist security info=False;initial
catalog=pubs

I'm trying to grasp the concept but it's frustrating.

So, now you should know all about my web form.

Any ideas on how to fix my problem?

I will pay a million dollars for the answer to this problem. :-)

Thanks,
T.

End Sub

"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns948CEBA55DYazorman@.127.0.0.1...
> Taishi (taishi_bak@.hotmail.com) writes:
> > Do you know how to use Enterprise Manager?
> Barely. :-) I prefer to carry most of my task by submitting T-SQL
> commands from Enterprise Manager.
> > I was able to find a trial version of the Enterprise Manager.
> > After reading my error today, I can see there is a problem with 2 dbases
> > 'PUBS' and 'Master'
> > CREATE DATABASE permission denied in database 'master'. Could not attach
> > database 'pubs' to file 'D:\Program Files\Microsoft SQL
> > Server\MSSQL$NETSDK\Data\pubs.mdf'.
> But you still have not told us what that web form is doing! Sorry, I
> cannot give much precise help if you don't explain what you are trying
> to do.
> But for the record, master and pubs are both databases that comes with
> SQL Server, but they are very different. pubs is a regular user database,
> and is there for demonstration and training purposes. master on the
> other hand, is, as the name, indicates the master database. In this
> database, SQL Server stores all server-wide information, for instance
> which databases there are.
> So the permission error applies to the master database, not to pubs.
> I can't tell why you get this error, because I don't know what you
> are doing (and you refuse to tell me). But since pubs already exist,
> you cannot attach it anyway.
> Anyway, what I tried to tell you last time, is that the web server
> needs to connect to SQL Server with sysadmin privileges to create
> databases, and to do that it must either log in as "sa" using SQL
> Server authentication, or log using Windows authentication with an
> account that has Administrator rights in Windows, or which have been
> added to the sysadmin role in SQL Server.
> So the rights you should are those that the IIS account has.
> --
> Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||Taishi (taishi_bak@.hotmail.com) writes:
> I didn't close my conPubs()-->MyConnection. That's one reason why I was
> receiving the error before. But now my problem is that the ListBox is not
> populating. The form just has a box that is empty. Seems simple for an
> experienced programmer but I'm not at the level, yet.
> In the Properties for MyConnection I have the following as my Connection
> String:
> workstation id=MyMachineName;packet size=4096;integrated
> security=SSPI;data
> source="MyMachineName\vsdotnet";attachdbfilename="D:\Program
> Files\Microsoft SQL Server\MSSQL$NETSDK\Data\pubs.mdf";persist security
> info=False;initial catalog=pubs
> In the Properties for MyCommand I have the following as my Connection
> String:
> workstation id=MyMachineName;packet size=4096;integrated
> security=SSPI;data
> source="MyMachineName\vsdotnet";attachdbfilename="D:\Program
> Files\Microsoft SQL Server\MSSQL$NETSDK\Data\pubs.mdf";persist security
> info=False;initial catalog=pubs

Ah, we're on to something here. Take out that "attachdbfilename" from
your Connection string. I see in MSDN Library, that this property is
actually supported for SqlClient, although I cannot understand the point
with it. Anyway, since pubs is already attached, you have no reason
to meddle with it.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp