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.
| Author |
Topic |
|
anomie
Starting Member
16 Posts |
 Posted - 2009-01-27 : 14:04:57
|
| Hi there,I have constructed a site using asp.net nd i am unable to fire it up onto a browser to test it. Using visual web developer, i press F5 and immediately i get a login error saying that i havent the full access rights to the database i have implemented.Using windows xp home, is there a way to change these access rights through visual web developer? I'm currently using sql Express server.Many thanx |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
anomie
Starting Member
16 Posts |
Posted - 2009-01-28 : 10:22:48
|
quote:
Originally posted by tkizer
Please post the full error message.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Hi Tara, thanx for your concern.When i run the site, visual web developer returns the following error message:Cannot open database "SnookerShop" requested by the login. The login failed.Login failed for user 'RICHARD-FB007F3\Richard'.Perhaps i need to create a new user, then set the permissions for the new user. I have tried to do this with sql server 2005 manager but im unable to configure sql server express. I think visual web developer ships a server called Cassini. Would i have to manage that server instance instead? I'm truly lost |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
anomie
Starting Member
16 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
anomie
Starting Member
16 Posts |
Posted - 2009-01-28 : 15:50:43
|
| I cannot login to sql express through management studio. It says it doesn't support sql Express. Is there an alternative way, perhaps through visual web developer? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
changing database access permissions