September 21, 2008 at 5:21 am
can I create db's and diagrams with managment studio express 2005??? I set the owner value to default when I create the db and I get the following message:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Create failed for Database 'asd'. (Microsoft.SqlServer.Express.Smo)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)
I changed the owner value to both sa and builtin/users but I get the same message...Any ideas???
September 21, 2008 at 8:24 am
Looks like your login doesn't have create database privileges. Are you the admin of that server? If not, can you speak with the admin and see if you have the appropriate permissions?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 21, 2008 at 8:33 am
It's my home pc, I checked out my account in the control panel and I am the admin...
Surfing the net I found out that I can solve this problem by opening Surface area configuration and adding a new admin...I tried to do so but this option does not appear anywhere...I am sure that I am the admin of my pc
note that I run Sql server 2005 EXPRESS on Vista...does that affect my problem in any way?
September 21, 2008 at 10:11 am
If you're running 2005 on Vista, being the machine's admin does not guarantee that you are sysadmin in SQL server. You'll have to explicitly add yourself as admin to SQL.
If you open surface area config, there will be an option 'add an administrator'. It's on the first screen that opens, towards the top. If it's not there, you can run SqlProv.exe. On my machine it's under "C:\Program Files (x86)\Microsoft SQL Server\90\Shared"
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 21, 2008 at 11:51 am
No there is no such exe...!!!
September 21, 2008 at 11:58 am
Please connect to the edition that you're trying to create the diagrams on and run the following:
select @@version
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 21, 2008 at 12:03 pm
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6000: )
September 21, 2008 at 1:17 pm
Versions of SQL 2005 prior to SP2 don't run properly on Vista and you have RTM there.
Can you download the SP2 version of express and install that over the version you have. It will add the admin provisioning tool in.
http://www.microsoft.com/sql/editions/express/default.mspx
http://www.microsoft.com/sql/howtobuy/windowsvistasupport.mspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 21, 2008 at 1:39 pm
I am downloading right now...I hope this works
September 21, 2008 at 2:12 pm
Thanx a lot, finally Sql on my pc...
September 21, 2008 at 2:14 pm
Pleasure.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply