Connecting to SQL express
-
Hi I have been trying to connect to a sql server database that is on my machine. I am using Visual Studio 2005. Every time I try connect I get an error message that states that the Login was invalid. I am getting this error msg. System.Data.SqlClient.SqlException was unhandled Class=14 ErrorCode=-2146232060 LineNumber=0 Message="Login failed for user 'sa'." Number=18456 Procedure="" Server="chiko-shumba" Source=".Net SqlClient Data Provider" State=1 This is connection string that I am using. cstring = "Persist Security Info=False;User ID=sa;Password=bobsurunlce;Initial Catalog=ymca_data;Server= chiko-shumba" I created my database using sql server 2000, and I assigned a usere name and password, when I installed sql server. What could I Have done wrong, and what can I do to get round this? thanks in advance twsted F8
-
Hi I have been trying to connect to a sql server database that is on my machine. I am using Visual Studio 2005. Every time I try connect I get an error message that states that the Login was invalid. I am getting this error msg. System.Data.SqlClient.SqlException was unhandled Class=14 ErrorCode=-2146232060 LineNumber=0 Message="Login failed for user 'sa'." Number=18456 Procedure="" Server="chiko-shumba" Source=".Net SqlClient Data Provider" State=1 This is connection string that I am using. cstring = "Persist Security Info=False;User ID=sa;Password=bobsurunlce;Initial Catalog=ymca_data;Server= chiko-shumba" I created my database using sql server 2000, and I assigned a usere name and password, when I installed sql server. What could I Have done wrong, and what can I do to get round this? thanks in advance twsted F8
twsted f8 wrote:
Connecting to SQL express
twsted f8 wrote:
I created my database using sql server 2000, and I assigned a usere name and password, when I installed sql server. What could I Have done wrong, and what can I do to get round this?
Okay. So, you created the database in SQL Server 2000, but have since moved it to SQL Server 2005 Express (the is no express edition for SQL Server 2000). The sa password you set in SQL Server 2000 won't apply in SQL Server 2005 as the login details are managed by the server not the individual databases. So you have to use what ever credentials were set up when you installed SQL Server 2005 Express Edition. It's been a while since I tried to install that edition but as I recall it doesn't ask you, it just sets up trusted connections automatically. I may be wrong so you might want to check.
Upcoming FREE developer events: * Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website
-
Hi I have been trying to connect to a sql server database that is on my machine. I am using Visual Studio 2005. Every time I try connect I get an error message that states that the Login was invalid. I am getting this error msg. System.Data.SqlClient.SqlException was unhandled Class=14 ErrorCode=-2146232060 LineNumber=0 Message="Login failed for user 'sa'." Number=18456 Procedure="" Server="chiko-shumba" Source=".Net SqlClient Data Provider" State=1 This is connection string that I am using. cstring = "Persist Security Info=False;User ID=sa;Password=bobsurunlce;Initial Catalog=ymca_data;Server= chiko-shumba" I created my database using sql server 2000, and I assigned a usere name and password, when I installed sql server. What could I Have done wrong, and what can I do to get round this? thanks in advance twsted F8
With SQL express you are going to have to allow access via TCP/IP from the SQL Server Configuration Manager.
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture) http://www.frankkerrigan.com/[^]