Can not connect to my database from asp .net application
-
I have a named instance of 2008 r2 located on my windows 7 professional local machine. I have tried to get my connect string to work but I just cant. I am using machine name "HOLDORF-PC" SQL instance name "SQL_2008_R2" and the rest of the connection string. Here is my connection string: "Data Source=HOLDORF-PC\\SQL_2008_R2;Initial Catalog=EFDataModel" providerName="System.Data.SqlClient" /> Please help Steve Holdorf
-
I have a named instance of 2008 r2 located on my windows 7 professional local machine. I have tried to get my connect string to work but I just cant. I am using machine name "HOLDORF-PC" SQL instance name "SQL_2008_R2" and the rest of the connection string. Here is my connection string: "Data Source=HOLDORF-PC\\SQL_2008_R2;Initial Catalog=EFDataModel" providerName="System.Data.SqlClient" /> Please help Steve Holdorf
-
I tried this: "Data Source=HOLDORF-PC\\SQL_2008_R2;Initial Catalog=EFDataModel; Integrated Security=SSPI" providerName="System.Data.SqlClient" and it still does not work?
-
I tried this: "Data Source=HOLDORF-PC\\SQL_2008_R2;Initial Catalog=EFDataModel; Integrated Security=SSPI" providerName="System.Data.SqlClient" and it still does not work?
Sorry, I tried this: "Data Source=HOLDORF-PC\\SQL_2008_R2;Initial Catalog=EFDataModel; Integrated Security=True" and it still doesn't work. One point is that this is the connection string that coexists with my Entity Framework model.
-
Sorry, I tried this: "Data Source=HOLDORF-PC\\SQL_2008_R2;Initial Catalog=EFDataModel; Integrated Security=True" and it still doesn't work. One point is that this is the connection string that coexists with my Entity Framework model.
OK. I think you were right on the DB connection string. Now, I'm getting this error: An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct. Here is my Entity Framework connection string: And here is my Model connections:
-
OK. I think you were right on the DB connection string. Now, I'm getting this error: An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct. Here is my Entity Framework connection string: And here is my Model connections:
-
OK. I think you were right on the DB connection string. Now, I'm getting this error: An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct. Here is my Entity Framework connection string: And here is my Model connections:
lholdorf wrote:
Check the inner exceptions for details and ensure that the connection string is correct.
This is a good time to post the inner exceptions.
Wrong is evil and must be defeated. - Jeff Ello[^]
-
I have a named instance of 2008 r2 located on my windows 7 professional local machine. I have tried to get my connect string to work but I just cant. I am using machine name "HOLDORF-PC" SQL instance name "SQL_2008_R2" and the rest of the connection string. Here is my connection string: "Data Source=HOLDORF-PC\\SQL_2008_R2;Initial Catalog=EFDataModel" providerName="System.Data.SqlClient" /> Please help Steve Holdorf
Where does your asp.net application run - on the same machine? If not, configure the SQL Server to accept connections from other machines. And what about the account the IIS is running with? Does that account have sufficient access rights to the database? I suggest SQL Server authentication instead of WIndows authentication - do not forget to configure your SQL Server to allow that.
-
I have a named instance of 2008 r2 located on my windows 7 professional local machine. I have tried to get my connect string to work but I just cant. I am using machine name "HOLDORF-PC" SQL instance name "SQL_2008_R2" and the rest of the connection string. Here is my connection string: "Data Source=HOLDORF-PC\\SQL_2008_R2;Initial Catalog=EFDataModel" providerName="System.Data.SqlClient" /> Please help Steve Holdorf
lholdorf wrote:
HOLDORF-PC\\SQL_2008_R2
Is the double back-slash between the machine name and the instance name a typo in your question, or a mistake in copying the connection string from a C# source file to the web.config file?
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
I have a named instance of 2008 r2 located on my windows 7 professional local machine. I have tried to get my connect string to work but I just cant. I am using machine name "HOLDORF-PC" SQL instance name "SQL_2008_R2" and the rest of the connection string. Here is my connection string: "Data Source=HOLDORF-PC\\SQL_2008_R2;Initial Catalog=EFDataModel" providerName="System.Data.SqlClient" /> Please help Steve Holdorf
I think you have to provide user name and password also...! I used As : Database Connection[^]
