connecting to sql sever
-
hello , I am learning ASP.NET I have one problem .... when in my web project I click on add new item -> sql database ..... it gives me message "Generating User Instance in SQL Server is disebled . use sp_configure 'user instance enabled' to generate user instace..... I dont know what to do and how to do. Please help me in solveing this problem.I am using visual web developer 2005 and sql server 2005 express. thanks ciacia
-
hello , I am learning ASP.NET I have one problem .... when in my web project I click on add new item -> sql database ..... it gives me message "Generating User Instance in SQL Server is disebled . use sp_configure 'user instance enabled' to generate user instace..... I dont know what to do and how to do. Please help me in solveing this problem.I am using visual web developer 2005 and sql server 2005 express. thanks ciacia
Howdy I don't think you want to add a new sql server database. You probably want to add an existing database server to the project. View the Server Explorer (View > Server Explorer), right click database connections > add connection. Don't forget that the connection string for SQLServer Express is slightly different to SQLServer. The host should be
localhost\sqlexpressIf you just want a connection string to a server then just add one to the web.config You can also drag a SQLDataSource onto a webpage to get a wizard that will help you go through the process (I think) Cheers Q