I'm developing my website in my docs. Once I get a version that is stable I move it over to inetput/wwwroot. When I login to my site it says it failed to generate a user instance... for (Server)/aspnet. However, I have specified a username / password in my connection string. Any ideas?
<addname="tppConnection"connectionString="Server=(local)\SqlExpress;Database=theProductPad;User ID=username;Password=password;"providerName="System.Data.SqlClient"/>
Hi,
You may install the SQL Management Studio 2005 Express first, create an account named "YOUR PC\ASPNET".And then create a database for the use of YOURPC\ASPNET with the help of SQL Management Studio Express. Finally in your Visual Studio, create a connection to the new database you just created. Select "SQL Server" as service provider, ".\SQLEXPRESS" as data source, and you will find your new database name as well as four system databases under the "select database". Test your connection. It should work!
Thanks.
|||
I did all of that a long time ago. Everything works fine if I'm using windows login security. However, this app won't be hosted on my local machine. I created a user and can login to sql server management studio and access everything that I need. I'm getting the error when I try to connect to the db through running my app or when I'm in the server explorer and try to change the login to the user I created.
|||Does anyone know what may be causing my site to use the default ASPNET user instead of the username/password in the connectionstring?
<add name="tppConnection" connectionString="Server=(local)\SqlExpress;Database=theProductPad;User ID=username;Password=password;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
|||
I deleted the string above, added a datalist and created a new connection string by the same name with all appropriate credentials and saved it to the web.config file and everything seems to be working now.
No comments:
Post a Comment