Showing posts with label basic. Show all posts
Showing posts with label basic. Show all posts

Sunday, February 12, 2012

Connecting to SQL Server from Web Server

This is probably a very basic question, but I'm not sure how to go about doing this. If I have a SQL server on our LAN and our Web server (running Microsoft Web Server OS) in my DMZ, and I want my Web server in the DMZ to be able to connect to the SQL server on the LAN, how do I go about doing that? Do I use an ODBC connection? I can't use SQL client tools because the Web Server OS will not allow me to install it. Any help would be great. Thanks in advance.

Ryan

Do you have it hooked up in your web.config file?

<connectionStrings>

<add name="LocalSqlServer" connectionString="Data Source=(local);Initial Catalog=DBNAME;Persist Security Info=True;User ID=XXX;Password=XXX;" providerName="System.Data.SqlClient"/
</connectionStrings>

Let me know.

|||

Well, I can run the .asp script from the SQL server itself. So the web config should be good. Thanks for the quick reply.

|||

The short answer is you can use anything you want, but you need to tell your firewall sitting between the DMZ and LAN to allow that type of traffic through the firewall.

A typical firewall rule would be to allow connections from your web server IP to your SQL Server IP over port X.

|||

I will look at the firewall. What is the "preferred" method to access the DB?

Friday, February 10, 2012

Connecting to SQL Server 2005 Express Edition from VS 2003?

Hi,

How do I connect to Sql Server 2005 express from Visual Basic. Net 2003 ?

Kumar

Hi,

normally this should be no problem, do you this programmatically or do you want to connect with the server explorer. Connecting with the server explorer should be no problem, which error are you getting ?

HTH, Jens Suessmeyer.


http://www.sqlserver2005.de

|||

Hi,

I am doing this with programmatically. Please help me on this isssue

|||


Hi,

just from notepad:

SqlConnection conn = new SqlConnection(getastringfromhttp://www.connectionstrings.com);

conn.Open();

For more detailed information, this is just the connection, northing more, see the Quickstart examples from microsoft or other sites on the internet, there should be tons of them :-)


HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Connecting to SQL Server 2005 Express

I am having major issues connecting to SQL Server 2005 Express from Visual Basic 2005 Express, which I have tried on multiple PCs but to no avail. Can somebody please explain to me what I'm doing wrong?

1) I install SQL Server 2005 Express and Visual Basic 2005 Express (With .NET framework and SQL native client of course)
2) I open SQL Server using Management Studio and going in with windows authentication. It automatically sets the log on name to computername\SQLEXPRESS.
3) I create a new database called Test and add one table to it
4) I go into Visual Basic 2005 and create a new project.
5) I go to the projects application settings (Properties - Settings).
6) I set up a new connection string, choosing SQL server as the conection type and then on the Connection Properties window it asks me to select the mdf file for the database. I choose the file Test.mdf from the directory C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
7) I click on Test Connection.

When I do this on two out of the three home PCs I get the error:
Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Test.mdf".Operating system error 32: "32 (error not found)".
An attempt to attach an auto-named database for file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Test.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

The third PC gives me a different error:

Cannot open user default database. Login failed. Login failed for user 'DAVE\David'.

I get the same errors when I try to use a connection string inside the code directly. Does anyone have a clue as to why these errors are occuring? Do I need to set up security or something else on the database first, or is there another reason? If anyone can please help me get to the bottom of this or provide a web address where I can get the answer (step by step instructions on how to connect) then I would be most grateful.

error code 32 means:
"The process cannot access the file because it is being used by another process."

So, either use a different file name for your connection in Visual Basic 2005, or try disconnect your connection in SQL Server using Management Studio.

|||

pse post the Connection string... it seems like u r trying to attach a db called Test....

in the second error .. check what is the Default Database given for user DAVE\David.... the default database should exists and this user should be a user of that db.... for debuggin purpose ... just change the default database of this user to Master and try... it will connect...

Madhu

|||

Hi, I get the same error as the original poster of this thread. I have no other database with similar name or anything, and i have not, as far as i know, any other connections to this database, since I just created it. Do you have any idea of how I should go about this?

Thanks

Niclas

Connecting to SQL Server 2005 Express

I am having major issues connecting to SQL Server 2005 Express from Visual Basic 2005 Express, which I have tried on multiple PCs but to no avail. Can somebody please explain to me what I'm doing wrong?

1) I install SQL Server 2005 Express and Visual Basic 2005 Express (With .NET framework and SQL native client of course)
2) I open SQL Server using Management Studio and going in with windows authentication. It automatically sets the log on name to computername\SQLEXPRESS.
3) I create a new database called Test and add one table to it
4) I go into Visual Basic 2005 and create a new project.
5) I go to the projects application settings (Properties - Settings).
6) I set up a new connection string, choosing SQL server as the conection type and then on the Connection Properties window it asks me to select the mdf file for the database. I choose the file Test.mdf from the directory C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
7) I click on Test Connection.

When I do this on two out of the three home PCs I get the error:
Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Test.mdf".Operating system error 32: "32 (error not found)".
An attempt to attach an auto-named database for file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Test.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

The third PC gives me a different error:

Cannot open user default database. Login failed. Login failed for user 'DAVE\David'.

I get the same errors when I try to use a connection string inside the code directly. Does anyone have a clue as to why these errors are occuring? Do I need to set up security or something else on the database first, or is there another reason? If anyone can please help me get to the bottom of this or provide a web address where I can get the answer (step by step instructions on how to connect) then I would be most grateful.

error code 32 means:
"The process cannot access the file because it is being used by another process."

So, either use a different file name for your connection in Visual Basic 2005, or try disconnect your connection in SQL Server using Management Studio.

|||

pse post the Connection string... it seems like u r trying to attach a db called Test....

in the second error .. check what is the Default Database given for user DAVE\David.... the default database should exists and this user should be a user of that db.... for debuggin purpose ... just change the default database of this user to Master and try... it will connect...

Madhu

|||

Hi, I get the same error as the original poster of this thread. I have no other database with similar name or anything, and i have not, as far as i know, any other connections to this database, since I just created it. Do you have any idea of how I should go about this?

Thanks

Niclas