How would Set permissions Sql Server 2005 so that I can access a asp page created in VWD and Sql Express.
On the production server i have just the one instance of Sql
I have the following connection string in the web config file:
<add name="ConnectionString" connectionString="server=serversName\XPRESS;uid=aspuser;pwd=aspuserPassworkd;database=DATABName" />
The account i setup to access the db in Sql 2005 Proper on the Production serve is Represented by the name in the above example as “aspuser”. I created this user in security, logins. And I gave permissions to this on the Db level “create procedure delete, select, update insert.”
I get a error when i run the page in the browser that says “login failed for aspuser.”
I know virtual directory is configured properly. I can run aspx page in the directory with out a db connection, without and error.
Any help would be greatly appreciated.