Connecting to SQL Server & XP Service Pack 2

I installed XP Service Pack 2 on my desktop machine which had SQL Server 2000
running on it prior to the install. I have a C# web application that runs
against a local SQL Server database which I cannot get to work now that I
have installed the XP service pack. I have read all of the Microsoft "HOW To"
documents about configuring SQL Server for the Service Pack but I still
cannot get the Web Appliation to communicate with the database. I always get
the "SQL Server does not exist or access denied." error message. I have tried
the following:
1. Added Port 1433 (TCP/IP) to the Firewall Exception List (1433 is the
static port SQL Server is using)
2. Added Port 445 (TCP/IP) to the Firewall Exception List
3. Added the sqlserver.exe file to the Firewall Exception List
The database connection string I am using in the web application is:
server=local;uid=sa;pwd=<password>;database=Resear ch
At this point I am not sure what else to try. I cannot connect to the
database if the Firewall is turned off. Should this be the case? Any
assistance is much appreciated.
Sincerely,
Tom Hessen
Hi Tom,
I had the same problem and decided to look at the other end of the
connection. I was running SQL Server ( Service Pack 2 ). When I upgraded
to SQL Server ( Service Pack 3a ) everything started working again.
"Tom Hessen" <Tom Hessen@.discussions.microsoft.com> wrote in message news:<645A76F5-D701-4411-9720-1C6AC67A7ED5@.microsoft.com>...
> I installed XP Service Pack 2 on my desktop machine which had SQL Server 2000
> running on it prior to the install. I have a C# web application that runs
> against a local SQL Server database which I cannot get to work now that I
> have installed the XP service pack. I have read all of the Microsoft "HOW To"
> documents about configuring SQL Server for the Service Pack but I still
> cannot get the Web Appliation to communicate with the database. I always get
> the "SQL Server does not exist or access denied." error message. I have tried
> the following:
> 1. Added Port 1433 (TCP/IP) to the Firewall Exception List (1433 is the
> static port SQL Server is using)
> 2. Added Port 445 (TCP/IP) to the Firewall Exception List
> 3. Added the sqlserver.exe file to the Firewall Exception List
> The database connection string I am using in the web application is:
> server=local;uid=sa;pwd=<password>;database=Resear ch
> At this point I am not sure what else to try. I cannot connect to the
> database if the Firewall is turned off. Should this be the case? Any
> assistance is much appreciated.
> Sincerely,
> Tom Hessen
|||Hi Tom,
I've had a little trouble posting, but hopefully this will get through.
I also did everything you listed below. It did not work for me
either ( for a java client ).
I then decided to look at the other end of the connection. I was running
SQLServer ( Service Pack 2 ). When I upgraded to SQLServer ( Service Pack
3a ) everything started working again.
Hope this helps,
Mike S.
"Tom Hessen" <Tom Hessen@.discussions.microsoft.com> wrote in message news:<645A76F5-D701-4411-9720-1C6AC67A7ED5@.microsoft.com>...
> I installed XP Service Pack 2 on my desktop machine which had SQL Server 2000
> running on it prior to the install. I have a C# web application that runs
> against a local SQL Server database which I cannot get to work now that I
> have installed the XP service pack. I have read all of the Microsoft "HOW To"
> documents about configuring SQL Server for the Service Pack but I still
> cannot get the Web Appliation to communicate with the database. I always get
> the "SQL Server does not exist or access denied." error message. I have tried
> the following:
> 1. Added Port 1433 (TCP/IP) to the Firewall Exception List (1433 is the
> static port SQL Server is using)
> 2. Added Port 445 (TCP/IP) to the Firewall Exception List
> 3. Added the sqlserver.exe file to the Firewall Exception List
> The database connection string I am using in the web application is:
> server=local;uid=sa;pwd=<password>;database=Resear ch
> At this point I am not sure what else to try. I cannot connect to the
> database if the Firewall is turned off. Should this be the case? Any
> assistance is much appreciated.
> Sincerely,
> Tom Hessen
sqlsql

Connecting to SQL Server & XP Service Pack 2

I installed XP Service Pack 2 on my desktop machine which had SQL Server 2000
running on it prior to the install. I have a C# web application that runs
against a local SQL Server database which I cannot get to work now that I
have installed the XP service pack. I have read all of the Microsoft "HOW To"
documents about configuring SQL Server for the Service Pack but I still
cannot get the Web Appliation to communicate with the database. I always get
the "SQL Server does not exist or access denied." error message. I have tried
the following:
1. Added Port 1433 (TCP/IP) to the Firewall Exception List (1433 is the
static port SQL Server is using)
2. Added Port 445 (TCP/IP) to the Firewall Exception List
3. Added the sqlserver.exe file to the Firewall Exception List
The database connection string I am using in the web application is:
server=local;uid=sa;pwd=<password>;database=Research
At this point I am not sure what else to try. I cannot connect to the
database if the Firewall is turned off. Should this be the case? Any
assistance is much appreciated.
Sincerely,
Tom HessenHi Tom,
I had the same problem and decided to look at the other end of the
connection. I was running SQL Server ( Service Pack 2 ). When I upgraded
to SQL Server ( Service Pack 3a ) everything started working again.
"Tom Hessen" <Tom Hessen@.discussions.microsoft.com> wrote in message news:<645A76F5-D701-4411-9720-1C6AC67A7ED5@.microsoft.com>...
> I installed XP Service Pack 2 on my desktop machine which had SQL Server 2000
> running on it prior to the install. I have a C# web application that runs
> against a local SQL Server database which I cannot get to work now that I
> have installed the XP service pack. I have read all of the Microsoft "HOW To"
> documents about configuring SQL Server for the Service Pack but I still
> cannot get the Web Appliation to communicate with the database. I always get
> the "SQL Server does not exist or access denied." error message. I have tried
> the following:
> 1. Added Port 1433 (TCP/IP) to the Firewall Exception List (1433 is the
> static port SQL Server is using)
> 2. Added Port 445 (TCP/IP) to the Firewall Exception List
> 3. Added the sqlserver.exe file to the Firewall Exception List
> The database connection string I am using in the web application is:
> server=local;uid=sa;pwd=<password>;database=Research
> At this point I am not sure what else to try. I cannot connect to the
> database if the Firewall is turned off. Should this be the case? Any
> assistance is much appreciated.
> Sincerely,
> Tom Hessen|||Hi Tom,
I've had a little trouble posting, but hopefully this will get through.
I also did everything you listed below. It did not work for me
either ( for a java client ).
I then decided to look at the other end of the connection. I was running
SQLServer ( Service Pack 2 ). When I upgraded to SQLServer ( Service Pack
3a ) everything started working again.
Hope this helps,
Mike S.
"Tom Hessen" <Tom Hessen@.discussions.microsoft.com> wrote in message news:<645A76F5-D701-4411-9720-1C6AC67A7ED5@.microsoft.com>...
> I installed XP Service Pack 2 on my desktop machine which had SQL Server 2000
> running on it prior to the install. I have a C# web application that runs
> against a local SQL Server database which I cannot get to work now that I
> have installed the XP service pack. I have read all of the Microsoft "HOW To"
> documents about configuring SQL Server for the Service Pack but I still
> cannot get the Web Appliation to communicate with the database. I always get
> the "SQL Server does not exist or access denied." error message. I have tried
> the following:
> 1. Added Port 1433 (TCP/IP) to the Firewall Exception List (1433 is the
> static port SQL Server is using)
> 2. Added Port 445 (TCP/IP) to the Firewall Exception List
> 3. Added the sqlserver.exe file to the Firewall Exception List
> The database connection string I am using in the web application is:
> server=local;uid=sa;pwd=<password>;database=Research
> At this point I am not sure what else to try. I cannot connect to the
> database if the Firewall is turned off. Should this be the case? Any
> assistance is much appreciated.
> Sincerely,
> Tom Hessen

Connecting to SQL Issue

I have a mdf file and log file from msde. I have successfully connected to it in my Visual Studios ASP.net 2.0 Desktop. I am having a problem where it connects. fine but it does not list the tables , diagrams etc. I am trying to build the intake screen with this data but have no tables. Can some one give me a couple of suggestions of why? I am very new to ASP.net and would appreciate any help .How did you connect to the MSDE mdf file? Can you create a Data Connection to it in Server Explorer? Which SQL instance are you using (MSED,SQL Express, etc.)?|||

Hello,

I am using SQL Server Management Studio that came with my visual studios .net 2005.

I open my web application to the design desktop select the tab labeled Server Express the click on the data base to connect it tell me it is connected but no tables show. I was told today by some one I need to be running SQL Server Studio Express I dont understand is the one I have better? The also told me the mdf file was a backup file which they said I need to create a database and then import the mdf backup file into it . I can figure out how to do this I am very new to SQL Server. Help please

Thanks

|||Where does the mdf file come from? Anyways you should attach it to your current SQL instance before you can use it. To do this in Managment Studio, right click Databases in Object Explorer->choose Attach->locate the mdf file. If attach succeeds, you'll see the new attached database under the Databases tree.|||

Thank you,

I found the mdf file to be a bak file I created anew database and restored over the database I created. All tables showed up ok. I only have on question everything seem to work fine except I have no diagrams under the database is this normal not to have this information?

sqlsql

Connecting to SQL

I have a problem in connecting to an SQL database on a server from laptop
computers. The users can access it from a desktop with same windows login as
they use on their laptop but all I get when they try on the laptop is an
error message saying connection failure. All machines are running XP and we
cannot find any differences in the setup.
If anyone has any advise or can point me in the right direction I would be
greatful.
TIA
Rob
Hi Rob,
Do you use sqlserver authentication or windows authentication on the
sqlserver ?
Ton
"Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
news:OGxRj9rtEHA.2664@.TK2MSFTNGP12.phx.gbl...
> I have a problem in connecting to an SQL database on a server from laptop
> computers. The users can access it from a desktop with same windows login
as
> they use on their laptop but all I get when they try on the laptop is an
> error message saying connection failure. All machines are running XP and
we
> cannot find any differences in the setup.
> If anyone has any advise or can point me in the right direction I would be
> greatful.
> TIA
> Rob
>
>
|||windows authentication. Although this has been partly resolved. The laptops
have been assigned fixed IP addresses which has allowed them to connect.
However I would ideally prefer a different workaround as fixed IP addresses
are not ideal.
Thanks
"Ton" <t.leer@.wanadoo.nl> wrote in message
news:4176ad6b$0$30709$18b6e80@.news.wanadoo.nl...
> Hi Rob,
> Do you use sqlserver authentication or windows authentication on the
> sqlserver ?
> Ton
> "Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
> news:OGxRj9rtEHA.2664@.TK2MSFTNGP12.phx.gbl...
> as
> we
>
|||This is a DNS issue and is not really related to SQL Server.
Michael Otey
"Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
news:O1Ljfq4tEHA.2316@.TK2MSFTNGP12.phx.gbl...
> windows authentication. Although this has been partly resolved. The
laptops
> have been assigned fixed IP addresses which has allowed them to connect.
> However I would ideally prefer a different workaround as fixed IP
addresses[vbcol=seagreen]
> are not ideal.
> Thanks
> "Ton" <t.leer@.wanadoo.nl> wrote in message
> news:4176ad6b$0$30709$18b6e80@.news.wanadoo.nl...
laptop[vbcol=seagreen]
login[vbcol=seagreen]
an[vbcol=seagreen]
and
>

Connecting to SQL

I have a problem in connecting to an SQL database on a server from laptop
computers. The users can access it from a desktop with same windows login as
they use on their laptop but all I get when they try on the laptop is an
error message saying connection failure. All machines are running XP and we
cannot find any differences in the setup.
If anyone has any advise or can point me in the right direction I would be
greatful.
TIA
RobHi Rob,
Do you use sqlserver authentication or windows authentication on the
sqlserver ?
Ton
"Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
news:OGxRj9rtEHA.2664@.TK2MSFTNGP12.phx.gbl...
> I have a problem in connecting to an SQL database on a server from laptop
> computers. The users can access it from a desktop with same windows login
as
> they use on their laptop but all I get when they try on the laptop is an
> error message saying connection failure. All machines are running XP and
we
> cannot find any differences in the setup.
> If anyone has any advise or can point me in the right direction I would be
> greatful.
> TIA
> Rob
>
>|||windows authentication. Although this has been partly resolved. The laptops
have been assigned fixed IP addresses which has allowed them to connect.
However I would ideally prefer a different workaround as fixed IP addresses
are not ideal.
Thanks
"Ton" <t.leer@.wanadoo.nl> wrote in message
news:4176ad6b$0$30709$18b6e80@.news.wanadoo.nl...
> Hi Rob,
> Do you use sqlserver authentication or windows authentication on the
> sqlserver ?
> Ton
> "Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
> news:OGxRj9rtEHA.2664@.TK2MSFTNGP12.phx.gbl...
> as
> we
>|||This is a DNS issue and is not really related to SQL Server.
Michael Otey
"Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
news:O1Ljfq4tEHA.2316@.TK2MSFTNGP12.phx.gbl...
> windows authentication. Although this has been partly resolved. The
laptops
> have been assigned fixed IP addresses which has allowed them to connect.
> However I would ideally prefer a different workaround as fixed IP
addresses
> are not ideal.
> Thanks
> "Ton" <t.leer@.wanadoo.nl> wrote in message
> news:4176ad6b$0$30709$18b6e80@.news.wanadoo.nl...
laptop[vbcol=seagreen]
login[vbcol=seagreen]
an[vbcol=seagreen]
and[vbcol=seagreen]
>

Connecting to some remote Sql Server

Hi

I've got a desktop and a notebook and both are connected to the router. On both I've got Sql Server Express and Sql Server Management Studio Express installed. I need to connect to a remote Sql Server (using user ID and password) which works fine on my desktop, but fails on my notebook: Error:0 and Error: 10060.

I checked all router settings and notebook settings, but I don't know what I am doing wrong. I got myself another notebook and installed Sql Server Express plus Management Studio, which did not work either.

Hopefully someone can help.

Thank you.

The error code is of Socket error. It seems you are not able to get connected to your SQL server.

following should help you.

http://www.dameware.com/support/kb/article.aspx?ID=300060

|||

Hi, I am able to connect to the local Sql Server Express (running on the notebook) - only remote connections (at least the one I am trying) fail.

Thanks!

|||

The remote connection may be failing because of socket error. You might like to have a look at remote connection. You might also like to look at the SQL server to check if it allows remote connections.

Connecting to MSDE

I am trying to connect to a MSDE database on server from my desktop using query analyzer. I keep getting the generic "SQL Server does not exist or access denied'

I have verified the following:
- the login/password is valid because when I access osql from server I can gain access
- the registry for Loginmode appears OK - set to 2 - mixed mode

What else do I need to check...

Thanks, kgaskeDid MSDE install as a named instance? Check the service, and see if it is listed as MSSQL$foo. If it is, you connect as servername\foo.|||No MSDE is not a named instance. Checked the service..|||Can you connect to the server from the server? Maybe no network protocols were enabled.|||Can you connect to the server from the server? Maybe no network protocols were enabled.

I'll second this; what version of MSDE is it? What's the operating system. By default, MSDE 2000 installed on WXP or Win2003 will not enable IP connections. You have to install SP3 (minimum) or SP4. I also recall (from some dim memory) that by default, MSDE does not enable anything but shared memory (ie, localhost) connections.

Regards,

hmscott

connecting MSSQl Server in local IP

Hi

We are hosting a Database Server for our client server desktop application

The Database server(Microsoft SQL Server 2000) is in the internet with a Public IP as of now

Now we have planned to bring our SQL Server to Local IP i.e. behind firewall for security reasons

How this can be done? What should I do?

What are all the Possiblity solution?

What is the server name or IP should i give when a when my client application connects to the Database server.
How the connection can be established

anyone kindly tell me the possible methods so that my clients must be able to access the database server which is in local IP

Thanks and regards
Sabeerin "server network utility" enable Named Pipes protocol...you should be able it access it from your local network, or application using the database server name
(find this by running select @.@.servername on the server)
If you want it to still be accesible on the outside, leave TCP/IP enabled with ext ip in properties|||yes I understand

The Thing is My SQL Server is hosted by our Service Provider
Now What should I ask My Service Provider to do to bring it to local IP
as so far I was using Public IP.
So what should be done
So that my client application is able to to access the database server which is in Local network in the service Provider
Can you guide me further

Regards
Sabeer|||you need to ask your provider to set up a NAT (network address translation) for you. basically you will be asking them to forward any requests made on a certain port (1433 for sql default) on the external IP to the relevant port on your internal IP ...
client apps will still use external IP for connections...
cheers
des|||Hi

Thanks

I shall try it out with my Service Provider

Regards
Sabeer

Connecting an ADP to a remote MSSQL database on the same network

I installed MSSQL 2000 on my desktop (running NT 2000). No problem. I created an adp and attached it to a database within MSSQL 2000, no problem.

When I go into MS Access, on another PC (running Windows XP Pro) on the same network, and try to create a using 'Project(Existing Data)' and connect it to MSSQL 2000 on my desktop, I fill in the Data Link Properties '1. Select or enter server name', no problem, '2. I click on Use Windows NT integrated security ',no problem. On '3. Select the database on the server', I get the following message -
SQL Error [DBNETLIB]{ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

I've been to more websites then I can count to try and resolve this error to no avail. Could someone give me a simple solutions, or at least some direction on this.

Thanks in advance for any help you can provide.

BurtTry to create DSN instead and use it instead of Server name.

Good Luck

connect to sql server desktop engine over internet

i have got to connect to sql server desktop engine over internet with the following connection string

conString = "Provider=SQLOLEDB.1;Persist Security Info=True;Initial Catalog=" & dbName & ";Network Address=" & IPAddress & ";Data Source=" & DataSource & " ;User ID=" & UserId & " ; Password=" & Password

Plz also inform me about the restriction imposed in connectivity by any of the window operating system such as that win 98 wont work or work!

There is no firewall involved. The two computers are in the same room and connected directly to the internet.

Even the ping is not going to either computer.

So what could be the possible problem and the solution.

need urgentsetup a domain or at least a workgroup so you can access the resources on the msde machine from the other computer. untill you can at least ping it you won't be able to connect.

Connect to SQL from a different Subnet

Hi all,
I have my SQL 2000 server at 192.168.1.10. All of the
desktops with in that subnet can access the SQL server. I
just installed a new desktop with ip address: 192.168.3.2
Is there anything that i need to set up in order for this
desktop to be able to detect and connect to my SQL
Server. A ping from 192.168.3.2 to 192.168.1.10 receive
100% sucessful reply. I can even connect to the folders
on the SQL server but not to the database.
When i try to connect through a sql client it give
something like this: SQL server does not exist or access
is denied
Please help
ThanksYou need to retrieve the actual OS error to troubleshoot this problem.
Reply with the OS error returned while connecting using an ODBC test DSN.
Or test using ISQL.exe from a command prompt.
Example:
ISQL -Stcp:ServerNameHere -Usqluseridhere -Ppasswordhere -Q"select
@.@.version"
or
ISQL -Stcp:ServerNameHere -E -Q"select @.@.version"
Search the kb for the OS error returned.
Example:
10060 == Connection Timeout
10061 == Connection Refused. The server is not listening on TCP. This
could be caused if we fail to bind to the port.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.