473,322 Members | 1,620 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

SQL server 2000 connection fails

Hi

I published the problem below some days earlier in
xxx.dotnet.languages.vb.data and got no response. So I try here, maybe
someone can help me!

When developing on stand alone PC using VB .net (Visual Studio 2003)
and SQL server 2000, the connection is established using
SqlConnection.ConnectionString="integrated security=sspi;server=tangokilo;
initial catalog=Forecasting;persist security info=false"

If same code runs on networked machine with SQL Server 2000 on network (we
also tried running this server on local machine), the same code fails.

Where lies the problem? Can someone help, please?

Regards
Thomas

Nov 20 '05 #1
4 2403
What specific exception is being thrown?

Is this a named instance? If so, use WhatEverInstance\tangokilo for Data
Source. Also, stick with one connection
string style or the other... either of these should work.

Server=tangokilo;Database=Forecasting;Trusted_Conn ection=True;
Data Source=tangokilo;Initial Catalog=Forecasting;Integrated Security=SSPI;

My guess is that it's a named instance or it's the mixed connection string
style. If all else fails, try connecting
through Server Explorer in VS.NET and if it works, use the connection string
it creates modifying it where/if necessary
If not, verify that you have permissions to hit the server. I doubt it's
the problem but it is possible to log in on
an account, even if it's on the server, that can't get it.

HTH,

Bill

"tangokilo" <tk******@ozemail.com.au> wrote in message
news:hr****************@nnrp1.ozemail.com.au...
Hi

I published the problem below some days earlier in
xxx.dotnet.languages.vb.data and got no response. So I try here, maybe
someone can help me!

When developing on stand alone PC using VB .net (Visual Studio 2003)
and SQL server 2000, the connection is established using
SqlConnection.ConnectionString="integrated security=sspi;server=tangokilo;
initial catalog=Forecasting;persist security info=false"

If same code runs on networked machine with SQL Server 2000 on network (we
also tried running this server on local machine), the same code fails.

Where lies the problem? Can someone help, please?

Regards
Thomas

Nov 20 '05 #2
Hi there

You probably need to add the username and password in the
connection string.

Check http://www.connectionstrings.com/index.asp

Kind Regards
Jorge
-----Original Message-----
Hi

I published the problem below some days earlier in
xxx.dotnet.languages.vb.data and got no response. So I try here, maybesomeone can help me!

When developing on stand alone PC using VB .net (Visual Studio 2003)and SQL server 2000, the connection is established using
SqlConnection.ConnectionString="integrated security=sspi;server=tangokilo;initial catalog=Forecasting;persist security info=false"

If same code runs on networked machine with SQL Server 2000 on network (wealso tried running this server on local machine), the same code fails.
Where lies the problem? Can someone help, please?

Regards
Thomas

.

Nov 20 '05 #3
1) ping the server see if you get a reponse (network Ok)
2)could be a security issue

Try catching the sql exception to see what message you get:

try
Catch sqlexc As SqlException
msgbox(sqlexc)
end try
Nov 20 '05 #4
Thanks Adam,

We tried various things on target machine. Found that
1) local server defined as 'VIPER' named as VIPER didn't, eg.
server=VIPER;..."
2) local server defined as (local) suddenly worked, eg. server=(local);..."
3) server of network named as 'NT_SQL1' worked too...

Some days later, after reassembling code on target machine, local server
using (local) worked too. What happened...????)

Regards
Thomas
"adamz5" <ad****@hotmail.com> wrote in message
news:40**************************@posting.google.c om...
1) ping the server see if you get a reponse (network Ok)
2)could be a security issue

Try catching the sql exception to see what message you get:

try
Catch sqlexc As SqlException
msgbox(sqlexc)
end try

Nov 20 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Ringumol | last post by:
Hi, We have some console application which runs in background with the following logical flow : Main() { loop (1..n) { CreateThread(Function1) }
0
by: AlessanBar | last post by:
Hello Friends !! I have a strange problem, and I need to know what would be the source of this. I have a laptop computer with the following configuration: Pentium III Brand : Toshiba Speed :...
2
by: Ananta | last post by:
Hi I am having a problem with the SQL server connected in VC#.net I am using the SQLDataAdaptors to access and fill the data to the DataSets. There are certain pages in sequence which run...
2
by: Vaap | last post by:
I did lot of googling to see if I can solve the SQL server not found problem while trying to run ASP.Net community starter kit from an XP machine to Windows 2003 server hosting SQL server 2000...
1
by: Schalley Ben | last post by:
Hi First of all, this is my first post on a newsgroup so don't shoot me if I ask this in the wrong place. Here is the situation. I'm developing an asp.net application with access to a SQL...
1
by: finn clement hansen | last post by:
Hi group, being pretty new to setting up sql server, I am stuck. Have installed sql 2000 server on Win 2000 server, IIS 5.0. I try to connect via ASP script that looks like this: <% Set...
1
by: Vikram S | last post by:
Hi All, I have an ASP.NET 2.0 web application on a web server and a separate machine for SQL Server 2000 Database. I am using a Connectionstring based on Sql Authentication to connect to the...
3
by: =?Utf-8?B?ZGF2aWQ=?= | last post by:
Last week I asked a question about connection to database from client machine (developer machine). I have changed the database security setup for "SQL Server and Windows" under (local)Windows NT...
1
jamesd0142
by: jamesd0142 | last post by:
Can any one help me connect a a server and retrieve information from a DB usin vb.net and sql server 2000? server: ELWADB1 Table: Post16 Possible using windows authentication, otherwise any...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.