Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 how to create a sql svr account??

Author  Topic 

turkalpk
Starting Member

21 Posts

Posted - 2006-04-06 : 19:39:20
Hello , I am using sql svr 2005 ,I cannot deploy my db because local account does not have read rights , so how can I change it or how can I create a sql server account which has every rights (read,write,execute) to the database ??

F16 LÝGHTÝNÝNNNG

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-04-07 : 02:51:20
so the db is there but the account does not have permissions set to it?

don't be confused, it's the same as sql2000, just right click the user on the security folder then choose properties

or you can click on New Query and type in the tsql there

HTH

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -