Windows integrated Security issues
-
i am a part time student in web design and i am trying to learn asp.net and ado.net at the moment. i do not delve into SQL until a little bit later in my course. [i am using visual studio 2003 and sql server express 2005] i am having integrated security issues. i keep getting this message; "" ! ADO Error: ' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. "" i can vaguely remember somebody mentioning to me, that i must change the security settings within SQL Server to allow visual studio to communicate with it. i dont know whwat to change! and there are so many options and different security folders.. guest, dbo, etc.. any help would be timelessly appreciated many thanks in advance
John Michael Kinsella kinsellajohn@hotmail.com
-
i am a part time student in web design and i am trying to learn asp.net and ado.net at the moment. i do not delve into SQL until a little bit later in my course. [i am using visual studio 2003 and sql server express 2005] i am having integrated security issues. i keep getting this message; "" ! ADO Error: ' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. "" i can vaguely remember somebody mentioning to me, that i must change the security settings within SQL Server to allow visual studio to communicate with it. i dont know whwat to change! and there are so many options and different security folders.. guest, dbo, etc.. any help would be timelessly appreciated many thanks in advance
John Michael Kinsella kinsellajohn@hotmail.com
John, Make sure your connection string includes the following: ConnectionString = "Data Source=.\SQLEXPRESS;" _ + "Integrated Security=True;" _ + "AttachDBFilename=" + [DB filename and path] & ";" _ + "Initial Catalog=" + [DB filename] + ";" _ + "Connect Timeout=30;" _ + "User Instance=True" example: "Data Source=.\SQLEXPRESS;Integrated Security=True;AttachDBFilename=C:\mydb.mdf;Initial Catalog=mydb;Connect Timeout=60;User Instance=True"