connection issues

Hi,

what all I need to check / set in order to connect to the server using isql / osql / bcp , nothing is working for me. I am on server, using command prompt . I reinstalled client and I am able to connect to server using EM , QA no problem , only problem is using isql / osql / bcp as follows:

isql -Usa -SSQL2000 -Psa123

DB-Library: Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does not exist or network access denied.
Net-Library error 67: ConnectionOpen (Connect()).

for BCP :

bcp ##abc1 out abc1.out -Usa -SSQL2000 -Psa123

SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
SQLState = 01000, NativeError = 67
Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).

need to fix it today. please reply !Q1 what all I need to check / set in order to connect to the server using isql / osql / bcp , nothing is working for me.

A1 It depends on what the issue is. For example:

you may wish to use osql -SSQL2000 -E or the file
ConnectSql2000.udl.txt to verify connectivity (remove .txt extension, double click and test).

Something to consider:
Is this a default instance on a server named Sql2000 or a named instance?

{More detailed information (including the Sql Server, MDAC, etc. versions involved, etc.), should make it easier for others to provide more useful / helpful feedback.}|||RE:
you may wish to use osql -SSQL2000 -E or the file
ConnectSql2000.udl.txt to verify connectivity (remove .txt extension, double click and test).|||Dear DBA Guru,

Thanks for your reply. I download your file , removed .txt and double clicked on it got error after I clicked on test connection on Data Link Properties , error is :

Test connection failed because of an error in initializing provider.
[DBNETLIB][ConnectioOpen] (Connect()),]SQL server does not exist or access denied.

Test connection succeeded, if I select 'Microsoft OLE DB Provider for ODBC Drivers, and select a data source which I created for my server.

More info : its a named server , not default server. Its installed using SQLEVAL.exe downloaded from microsoft.com, version is SQL Server 2000.

Please help.

Originally posted by DBA
Q1 what all I need to check / set in order to connect to the server using isql / osql / bcp , nothing is working for me.

A1 It depends on what the issue is. For example:

you may wish to use osql -SSQL2000 -E or the file
ConnectSql2000.udl.txt to verify connectivity (remove .txt extension, double click and test).

Something to consider:
Is this a default instance on a server named Sql2000 or a named instance?

{More detailed information (including the Sql Server, MDAC, etc. versions involved, etc.), should make it easier for others to provide more useful / helpful feedback.}|||RE:
Thanks for your reply.
error is :
Test connection failed because of an error in initializing provider.
[DBNETLIB][ConnectioOpen] (Connect()),]SQL server does not exist or access denied.
Test connection succeeded, if I select 'Microsoft OLE DB Provider for ODBC Drivers, and select a data source which I created for my server.
More info : its a named server , not default server. Its installed using SQLEVAL.exe downloaded from microsoft.com, version is SQL Server 2000.
Q2 Please help.

You are welcome.

A2 Use osql (Isql does not support named instances), and for example:

-SServerName\InstanceName (to specify the server and instance)|||Hi Guru,

it worked. -SSERVERNAME\INSTANCENAME. Worked for isql , osql and BCP.

Much thanks for your help.

Cheers!
Ram|||RE
Hi Guru,
it worked. -SSERVERNAME\INSTANCENAME. Worked for isql , osql and BCP. Much thanks for your help.
Cheers! Ram

You are welcome.

You may wish to consider using osql instead of isql. While the isql.exe distributed with the eval version may work with named instances, isql does not (officially) support connecting to a named instance of SQL Server 2000. (Applications developed relying on the behavior of isql.exe distributed with the evaluation version may not perform as expected in production.)|||I will take it, I just more use to isql because I worked as a Sybase DBA. learning MS SQL Server. but I will use OSQL .

Thanks and Regards,
Ram|||Originally posted by ramshree
I will take it, I just more use to isql because I worked as a Sybase DBA. learning MS SQL Server. but I will use OSQL .

Thanks and Regards,
Ram

You are welcome.

(Just trying to spare you some grief, MS has kind of ignored support for isql in the past several years, since releasing osql. Evaluation and beta product differences have caused considerable pain as well.)

As far as Sybase goes, you are in good company, the MS Sql Server DBMS "worked" as a Sybase DBMS entity before becoming a MS entity, as well (numerous vestiges of that lineage still remain, even in MS Sql Server 2k).|||Hi Guru,

How are you?

I like Sybase more but have no choice since lot of companies moving from Sybase to either MS SQL Server, Oracle or DB2. and since I know Sybase very well , the close one to learn is SQL Server, 95% its same except GUI stuff of EM but I am not impress. still I like to work on UNIX .
Have you tried Perl scripting using DBI to do stuff of SQL Server? I dont know if I can write Perl script using DBI to do SQL Server database work on NT / Windows. have you wrote perl scripts using DBI on NT / Windows? Please let me know.

Thanks,
Ram.

Connection failed error during upsizing of an Access database to SQl Server Express databa

Hello,
In order to utilize an Access database as SQL Server database I use
Upsize wizard. I use (Local) SQL server and Trusted Connection. After some
wait I get the following error:
Connection failed:
SQL State:'01000'
SQL error Error:2
[Microsoft][ODBC Server Driver][Shared
Memory]ConnectionOpen(Connect())
Connection Failed:
SQL State:'08001'
SQL server Error:17
[Microsoft][ODBC Server Driver][Shared Memory]SQL Server does not
exist or access is denied
Under VS2008 I can connect to Northwind SQLServer Express database and
manipulate the data OK. So what can I do? Thank you.
Athena
Hello,
I found what's wrong. Server name comes by default as (local) I changed
to right one. It worked.
Athena
"Athena" <Nospam@.nospam.com> wrote in message
news:4616FCF7-A008-4D57-9FBE-480455B4E162@.microsoft.com...
> Hello,
> In order to utilize an Access database as SQL Server database I use
> Upsize wizard. I use (Local) SQL server and Trusted Connection. After some
> wait I get the following error:
> Connection failed:
> SQL State:'01000'
> SQL error Error:2
> [Microsoft][ODBC Server Driver][Shared
> Memory]ConnectionOpen(Connect())
> Connection Failed:
> SQL State:'08001'
> SQL server Error:17
> [Microsoft][ODBC Server Driver][Shared Memory]SQL Server does not
> exist or access is denied
> Under VS2008 I can connect to Northwind SQLServer Express database and
> manipulate the data OK. So what can I do? Thank you.
> Athena

Connection error after copying an rdl

Whenever I make a copy of an existing report (.rdl) in order to use it as a
template for a new report, I get the following error message when I try to
preview it:
An error has occurred during report processing.
Cannot create a connection to data source 'Prospect'
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
The originial copy of the report - in the same project - works without
error. Why is this happening. This requires me to start every report from
scratch, and since I have a lot of parameters and data sources, this is very
tedious.Since specific credential information is not stored in the .rdl so when you
attempt to preview the copied report you'll see this error until you modify
your report DataSource. If you modify your report DataSets to use a shared
DataSource, I don't believe you'll run into this.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jody Z" <Jody Z@.discussions.microsoft.com> wrote in message
news:B95FFD30-F0D5-4FAC-B6C9-6A91DD5DFAA0@.microsoft.com...
> Whenever I make a copy of an existing report (.rdl) in order to use it as
> a
> template for a new report, I get the following error message when I try to
> preview it:
> An error has occurred during report processing.
> Cannot create a connection to data source 'Prospect'
> Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL
> Server connection.
> The originial copy of the report - in the same project - works without
> error. Why is this happening. This requires me to start every report
> from
> scratch, and since I have a lot of parameters and data sources, this is
> very
> tedious.

Connecting to SQL server Over Internet/ Phone line etc.

In order for the application to work you need to be authenticated on the
wireless network. This really has nothing to do with SQL Server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.Hi Kevin,
Well the application work in 802.11g network.. but I want now it be able to
work outside the wireless network say view phone line connection or Internet
. That is my question. Any help will be appreciated.
Regards
Lisa|||Hi Lisa,
The same rules apply. If you're going to allow access via phone line,
then as long as the application can recover from a dropped line, there's no
reason why you couldn't do this. There may be some tcp parameters that you
might need to adjust to account for the slow line speed. You could also
experiment with changing the packetsize in SQL to 512.
Across the internet, you have much more bandwidth. The connection quality
and stability relies on the ISP provider.
Hope this helps
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.