| Author |
Topic |
|
rajen84
Starting Member
7 Posts |
 Posted - 2006-07-24 : 03:37:02
|
| I was just trying out Microsoft SQL Server 2000. I created a sample application which reads in 2 values from a textbox and writes it into a databse. This application works fine on my computer and the values are written to the database (In the connection string, I give my IP address as the datasource so that anyone on the internet can hit this database). However, when I copy this application to another computer and try to run it, it gives me an error "SQL Server does not exist or access is denied." I know this is a minor problem with some setting, but I haven't been able to find the solution on the internet. Can someone whose worked with Microsoft SQL Server 2000 please help me out. |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-07-24 : 03:43:22
|
| You are not able to access the SQL Server from the machine where you installed your application. Just check if you are able to connect to the SQL Server, using ODBC?Chirag |
 |
|
|
krittim
Starting Member
6 Posts |
Posted - 2006-07-25 : 07:58:25
|
| Try installing SP3 on that SQL Server 2000 machine. If required, change your SQL login to mixed mood & then try. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-25 : 09:02:22
|
| post your connectionstring, can you ping the sql server from that computer?--------------------keeping it simple... |
|
|
|
rajen84
Starting Member
7 Posts |
Posted - 2006-07-25 : 22:02:58
|
| SQL Server is already on mixed mode authentication. It is actually a VB.NET application. When i run the application on my machine, the values get inserted into the database since the database is hosted on my personal laptop. But when i run the same application from a friend's laptop, I get the error message "SQL Server does not exist or access is denied. Below is the snippet of my code:Dim insert_values as string = "'" + textbox1.text + "','" + textbox2.text + "'"Dim cnOra As New OleDbConnection("Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd") cnOra.Open() Dim cmdUpdate As New OleDbCommand _ ("INSERT INTO APP_STR(PARAM_NM,PARAM_VAL) VALUES(" + insert_values + ")", cnOra) cmdUpdate.CommandType = CommandType.Text cmdUpdate.ExecuteNonQuery()My friend is able to ping my laptop successfully and get a response but however a telnet fails with the message a telnet connection cannot be opened on port 1433. |
|
|
|
fasttrack
Starting Member
12 Posts |
Posted - 2006-08-03 : 12:37:51
|
| Look on sql server log file, check where is ip address and port.If port is different, replace the port 1433 with the port found in log file. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-03 : 13:34:48
|
| a couple of questions:1. what SQL service pack are you running? SELECT @@VERSION from query analyzer will tell you.2. Are you trying to connect to your database on your local LAN (using private IP addresses like 192.168.x.x) or are you trying to connect over the internet using public IP addresses?3. Do you have a default instance installed, or is this a named instance? -ec |
|
|
|
rajen84
Starting Member
7 Posts |
Posted - 2006-08-03 : 13:55:53
|
| 1. what SQL service pack are you running? SELECT @@VERSION from query analyzer will tell you.--Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2) 2. Are you trying to connect to your database on your local LAN (using private IP addresses like 192.168.x.x) or are you trying to connect over the internet using public IP addresses?--Its over a private subnet i guess. I am on 190.190.200.100 and my friend who is connecting to me is on 190.1190.200.101. Same wireless router is used.3. Do you have a default instance installed, or is this a named instance? -- I'm not sure.. How do I find out? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-03 : 14:04:21
|
| ok, the first step is to install SP3 or SP4 on your database. go to www.microsoft.com/sql and download and install that service pack and see if things change. A reboot is probably required after install btw.We'll talk about the other issues after you have done that.-ec |
|
|
|
FrancoisH
Starting Member
1 Post |
Posted - 2006-08-08 : 04:40:29
|
quote:
Originally posted by eyechart
ok, the first step is to install SP3 or SP4 on your database. go to www.microsoft.com/sql and download and install that service pack and see if things change. A reboot is probably required after install btw.We'll talk about the other issues after you have done that.HiHave problem connecting to sql server(private ip)Can you help?-ec
|
|
|
|
|
SQL Server Access across a remote machine