开发者

sql server EXPRESS instance with windows authentication does not have any permissions to create a db

开发者 https://www.devze.com 2023-03-19 00:48 出处:网络
sql server EXPRESS instance with windows authentication does not have any permissions to create a db.

sql server EXPRESS instance with windows authentication does not have any permissions to create a db.

i have installed VS 2008. so i got SQLEXpress installed. and then separately i installed management studio 2008.

When i connect to the instance using windows login, it connected. but It does not have permissions to create any db or create any login.

How 开发者_运维问答can i fix this permissions issue. My windows authentication does not have any permissions to do anything on my sqlexpress db.

can any one help on this..

errro: access denied. no permission..

thank you


I had the exact same problem. When I completely reinstalled SQL Server 2008 Express and Management Studio the problem was missing. Also when you install the SQL Server you can add password for 'sa' user.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号