Connect to a database
-
I am some what new at this, but I need some help connecting a sql database to my asp.net app, and I keep getting security errors. Now, I've connected to databases before, but that was in a class where our instructor created all of our dbs since it wasn't a database class. I've created the table using SQL Server Express 2005 and I am trying to connect it to a website I have built in Visual Studio 2005. What am I doing wrong?
-
I am some what new at this, but I need some help connecting a sql database to my asp.net app, and I keep getting security errors. Now, I've connected to databases before, but that was in a class where our instructor created all of our dbs since it wasn't a database class. I've created the table using SQL Server Express 2005 and I am trying to connect it to a website I have built in Visual Studio 2005. What am I doing wrong?
check your connection string and make sure that u write the server name and database name correct
-
check your connection string and make sure that u write the server name and database name correct
I'm not even getting that far. When I go to set up the settings to my sql connection I get an error saying that SQL server doesn't allow remote connections. Do I need to create a user in the security settings in the database and then use that account for authentication? I'm use to doing this in mysql and php, but not to sure with the setup with the Microsoft products.
-
I'm not even getting that far. When I go to set up the settings to my sql connection I get an error saying that SQL server doesn't allow remote connections. Do I need to create a user in the security settings in the database and then use that account for authentication? I'm use to doing this in mysql and php, but not to sure with the setup with the Microsoft products.
You need to run the Configuration Manager and set everything there...
-
I am some what new at this, but I need some help connecting a sql database to my asp.net app, and I keep getting security errors. Now, I've connected to databases before, but that was in a class where our instructor created all of our dbs since it wasn't a database class. I've created the table using SQL Server Express 2005 and I am trying to connect it to a website I have built in Visual Studio 2005. What am I doing wrong?