asp sql server: February 2012

Saturday, February 25, 2012

Connection error in sql server compact edition 2005

HI friends,

i m working on device application ..i m using sql server ce 2005 with c#.net ... but when i m trying to connect to database it shows me error that

"the database path not found ... please check the path [,,,filename,,,]"

my code is as below

private string ConnStr = "Data Source =\\My Documents\\Employee.sdf;";

private void cmdCheckConnecton_Click(object sender, EventArgs e)
{
try
{
cn = new System.Data.SqlServerCe.SqlCeConnection(ConnStr);
cn.Open();
MessageBox.Show(cn.State.ToString());
}
catch (SqlCeException ex)
{
MessageBox.Show(ex.Message.ToString());
}
}

i have my database in My Documents and the path is right still it shows the error

pls help if any one have a solution regarding this problem

thanxx

Zalak Shah

This is just a guess, but looking at my connection strings they have quotes around the Data Source, so maybe try adding those in.

private string ConnStr = "Data Source =\"\\My Documents\\Employee.sdf\";";

|||hi

i have done it but still it doesn't work

one more thing i want to tell u .. if i create the database on the same location even it is there it will create once again and no files will be create at that location that 's just a file in a memory .... and after that that memory file will accessed by that code and working perfectly as i needed

can u tell me one thing that location is in mobile device (Emulator) 's location or my hard drive's location

Connection error in sql server compact edition 2005

HI friends,

i m working on device application ..i m using sql server ce 2005 with c#.net ... but when i m trying to connect to database it shows me error that

"the database path not found ... please check the path [,,,filename,,,]"

my code is as below

private string ConnStr = "Data Source =\\My Documents\\Employee.sdf;";

i have my database in My Documents and the path is right still it shows the error

pls help if any one have a solution regarding this problem

thanxx

Zalak Shah

This is just a guess, but looking at my connection strings they have quotes around the Data Source, so maybe try adding those in.

private string ConnStr = "Data Source =\"\\My Documents\\Employee.sdf\";";

|||hi

i have done it but still it doesn't work

can u tell me one thing that location is in mobile device (Emulator) 's location or my hard drive's location

Connection Error in Sql server 2005

the site having connection problem like. It will work perfectly for the 20 or 30 days after that sql server gives error on openning connection.

Then i have to restart the server. wt could be the problem of

With regrds

B anna

What are the error messages you are seeing? Are you seeing them on all client machines or just a subset of them? What edition of SQL 2005 are you using? Any additional info would be great to help debug. Thanks!

Thanks,
Sam Lester (MSFT)

Connection Error from ASP.Net under IIS: provider: Named Pipes Provider, error: 40

We experience the 40 error when our Asp.net code runs under IIS and uses named pipes to a sql server 2005 named instance.

We've tried all suggestions found on blogs and KB articles such as making sure the named pipes protocol is enabled, making sure the Browser service is started, making sure Allow Remote Connections is enabled, making sure we're not using Asp.Net 2.0 membership providers, and the list goes on and on.

We boiled it down to a simple test scenario. We open a SqlConnection to the sql 2005 box in the code with the intention of binding a datareader to a gridview, but it never gets that far because the connection.Open() fails.

If we run this test application as a virtual directory in IIS and Asp.Net 2.0, the connection.Open() fails.

If we run this test application from Visual Studio .Net using Cassini (PWS), the connection.Open() succeeds and binds to the gridview.

What could be causing the connection to fail under IIS but succeed under Cassini? We've tried setting IIS to run as a domain user and with digest authentication enabled. That made no difference.

Any help or insight is appreciated!

Could you try to answer the following questions though some of them may be already implied by your post?

(1) Is this remote connection or local connection?

(2) Is the account that runing your visual studio.net the the same as your IIS. Do you impersonate client connection in IIS?

(3) Can you make direct connection to your backend sqlserver from your virtual studio or sql server management studio?

(4) Can you try connecting using TCP instead? If not, what is the error code?

|||

(1) Is this remote connection or local connection?

-Remote connection

(2) Is the account that runing your visual studio.net the the same as your IIS. Do you impersonate client connection in IIS?

-Same account, windows authentication. No impersonation

(3) Can you make direct connection to your backend sqlserver from your virtual studio or sql server management studio?

-Management Studio works, Cassini works.. IIS does not

(4) Can you try connecting using TCP instead? If not, what is the error code?

TCP gives "server actively refused connection" error

|||

Does your connection string like "servername\instancename" or something else?

The TCP failure indicates either the server TCP listener is not up or client uses different TCP port to connect. So please check whether the TCP is enabled or not. Restart the server after the configuration change. Then check if the connection string has instancename specified. Once you find out which port the server is listening on, you can also use "tcpervername,port" to connection to the server.

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.

Connection error after already connected

I am using Access 2002 as a front end and SQL Server 2000 as a back end.
After I have connected, I use ADO to run a process that gets ten different
sum queries from various SQL Server tables and writes the results to local
Access table. This loops thru 300 to 800 records.
The second time thru this process, at any of the queries, I will almost
always get this error:
-2147467259, Sql Server does not exist or access denied. Now I am already
connected and I have run this same query many times.
If I debug and force the same line, it runs.
Why is it hanging occasionally, and more importantly, what can I do to fix
this?
TIA,
Mike
Are you using named pipes or tcp/ip ?
Vikram
"Michael Beck" <mikeb@.Nospamamuletc.com> wrote in message
news:OxuPzTwTEHA.3336@.TK2MSFTNGP10.phx.gbl...
> I am using Access 2002 as a front end and SQL Server 2000 as a back end.
> After I have connected, I use ADO to run a process that gets ten different
> sum queries from various SQL Server tables and writes the results to local
> Access table. This loops thru 300 to 800 records.
> The second time thru this process, at any of the queries, I will almost
> always get this error:
> -2147467259, Sql Server does not exist or access denied. Now I am already
> connected and I have run this same query many times.
> If I debug and force the same line, it runs.
> Why is it hanging occasionally, and more importantly, what can I do to fix
> this?
> TIA,
> Mike
>
|||TCP/IP
"Vikram Vamshi" <vikram.vamshi@.nospam.com> wrote in message
news:efh1gyyTEHA.3180@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Are you using named pipes or tcp/ip ?
> Vikram
> "Michael Beck" <mikeb@.Nospamamuletc.com> wrote in message
> news:OxuPzTwTEHA.3336@.TK2MSFTNGP10.phx.gbl...
different[vbcol=seagreen]
local[vbcol=seagreen]
already[vbcol=seagreen]
fix
>

Connection error after already connected

I am using Access 2002 as a front end and SQL Server 2000 as a back end.
After I have connected, I use ADO to run a process that gets ten different
sum queries from various SQL Server tables and writes the results to local
Access table. This loops thru 300 to 800 records.
The second time thru this process, at any of the queries, I will almost
always get this error:
-2147467259, Sql Server does not exist or access denied. Now I am already
connected and I have run this same query many times.
If I debug and force the same line, it runs.
Why is it hanging occasionally, and more importantly, what can I do to fix
this?
TIA,
MikeAre you using named pipes or tcp/ip ?
Vikram
"Michael Beck" <mikeb@.Nospamamuletc.com> wrote in message
news:OxuPzTwTEHA.3336@.TK2MSFTNGP10.phx.gbl...
> I am using Access 2002 as a front end and SQL Server 2000 as a back end.
> After I have connected, I use ADO to run a process that gets ten different
> sum queries from various SQL Server tables and writes the results to local
> Access table. This loops thru 300 to 800 records.
> The second time thru this process, at any of the queries, I will almost
> always get this error:
> -2147467259, Sql Server does not exist or access denied. Now I am already
> connected and I have run this same query many times.
> If I debug and force the same line, it runs.
> Why is it hanging occasionally, and more importantly, what can I do to fix
> this?
> TIA,
> Mike
>|||TCP/IP
"Vikram Vamshi" <vikram.vamshi@.nospam.com> wrote in message
news:efh1gyyTEHA.3180@.TK2MSFTNGP11.phx.gbl...
> Are you using named pipes or tcp/ip ?
> Vikram
> "Michael Beck" <mikeb@.Nospamamuletc.com> wrote in message
> news:OxuPzTwTEHA.3336@.TK2MSFTNGP10.phx.gbl...
different[vbcol=seagreen]
local[vbcol=seagreen]
already[vbcol=seagreen]
fix[vbcol=seagreen]
>

connection error after 15 minutes of restart

I have a problem with ms sql 2000 installed on windows 2000 server.
Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
Last night security update pack for IE 6 with SP1 was installed on the
server (KB867801)
Since morning sql server is working for 15 minutes, then connection is
not available - I got connection error message: msg: 17, level 16, state
1, SQL Server does not exists or access denied
After restarting SQL Server all works fine for about 15 minutes.
any clue ?
regardsMike Epprecht (SQL MVP) wrote:
> Have you checked the SQL event log for errors?
> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and check
> the number of connections.
> Regards
> Mike
>
> "yooyoo" wrote:
>
>>I have a problem with ms sql 2000 installed on windows 2000 server.
>>Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>>Last night security update pack for IE 6 with SP1 was installed on the
>>server (KB867801)
>>Since morning sql server is working for 15 minutes, then connection is
>>not available - I got connection error message: msg: 17, level 16, state
>>1, SQL Server does not exists or access denied
>>After restarting SQL Server all works fine for about 15 minutes.
>>any clue ?
>>regards
I will do it in some 10 minutes - I restarted server 5 minutes ago.
In SQL Log I have errors:
server SuperSocket Info: Bind failed on TCP port 1433.
server Error: 17882, Severity: 18, State: 1
server Error accepting connection request via Net-Library 'SSNETLIB'.
Execution continuing...
server Error: 17059, Severity: 18, State: 0
server Operating system error 0: The operation completed successfully...|||yooyoo wrote:
> Mike Epprecht (SQL MVP) wrote:
>> Have you checked the SQL event log for errors?
>> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and
>> check the number of connections.
>> Regards
>> Mike
>>
>> "yooyoo" wrote:
>>
>> I have a problem with ms sql 2000 installed on windows 2000 server.
>> Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>> Last night security update pack for IE 6 with SP1 was installed on
>> the server (KB867801)
>> Since morning sql server is working for 15 minutes, then connection
>> is not available - I got connection error message: msg: 17, level 16,
>> state 1, SQL Server does not exists or access denied
>> After restarting SQL Server all works fine for about 15 minutes.
>> any clue ?
>> regards
> I will do it in some 10 minutes - I restarted server 5 minutes ago.
> In SQL Log I have errors:
> server SuperSocket Info: Bind failed on TCP port 1433.
> server Error: 17882, Severity: 18, State: 1
> server Error accepting connection request via Net-Library 'SSNETLIB'.
> Execution continuing...
> server Error: 17059, Severity: 18, State: 0
> server Operating system error 0: The operation completed successfully...
sp_who returned 31 rows|||yooyoo wrote:
> yooyoo wrote:
>> Mike Epprecht (SQL MVP) wrote:
>> Have you checked the SQL event log for errors?
>> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and
>> check the number of connections.
>> Regards
>> Mike
>>
>> "yooyoo" wrote:
>>
>> I have a problem with ms sql 2000 installed on windows 2000 server.
>> Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>> Last night security update pack for IE 6 with SP1 was installed on
>> the server (KB867801)
>> Since morning sql server is working for 15 minutes, then connection
>> is not available - I got connection error message: msg: 17, level
>> 16, state 1, SQL Server does not exists or access denied
>> After restarting SQL Server all works fine for about 15 minutes.
>> any clue ?
>> regards
>>
>> I will do it in some 10 minutes - I restarted server 5 minutes ago.
>> In SQL Log I have errors:
>> server SuperSocket Info: Bind failed on TCP port 1433.
>> server Error: 17882, Severity: 18, State: 1
>> server Error accepting connection request via Net-Library 'SSNETLIB'.
>> Execution continuing...
>> server Error: 17059, Severity: 18, State: 0
>> server Operating system error 0: The operation completed successfully...
>
> sp_who returned 31 rows
The problem was another instance running on the server. But why it all
worked ok untill IE pack ?
regards,|||yooyoo wrote:
> yooyoo wrote:
>> yooyoo wrote:
>> Mike Epprecht (SQL MVP) wrote:
>> Have you checked the SQL event log for errors?
>> Using Query Analyzer, run sp_who or sp_who2 when the error occurs
>> and check the number of connections.
>> Regards
>> Mike
>>
>> "yooyoo" wrote:
>>
>> I have a problem with ms sql 2000 installed on windows 2000 server.
>> Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>> Last night security update pack for IE 6 with SP1 was installed on
>> the server (KB867801)
>> Since morning sql server is working for 15 minutes, then connection
>> is not available - I got connection error message: msg: 17, level
>> 16, state 1, SQL Server does not exists or access denied
>> After restarting SQL Server all works fine for about 15 minutes.
>> any clue ?
>> regards
>>
>> I will do it in some 10 minutes - I restarted server 5 minutes ago.
>> In SQL Log I have errors:
>> server SuperSocket Info: Bind failed on TCP port 1433.
>> server Error: 17882, Severity: 18, State: 1
>> server Error accepting connection request via Net-Library 'SSNETLIB'.
>> Execution continuing...
>> server Error: 17059, Severity: 18, State: 0
>> server Operating system error 0: The operation completed successfully...
>>
>> sp_who returned 31 rows
>
> The problem was another instance running on the server. But why it all
> worked ok untill IE pack ?
> regards,
>
I was too much optimistic. The nightmare started again at 8 a.m. :-(
I try to change port to somethign alse than 1433.
Hope reistall will help
regards|||Mike Epprecht (SQL MVP) wrote:
> Have you checked the SQL event log for errors?
> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and check
> the number of connections.
> Regards
> Mike
>
> "yooyoo" wrote:
>
>>I have a problem with ms sql 2000 installed on windows 2000 server.
>>Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>>Last night security update pack for IE 6 with SP1 was installed on the
>>server (KB867801)
>>Since morning sql server is working for 15 minutes, then connection is
>>not available - I got connection error message: msg: 17, level 16, state
>>1, SQL Server does not exists or access denied
>>After restarting SQL Server all works fine for about 15 minutes.
>>any clue ?
>>regards
sp_who returns just 31 rows
but there huge list on port mapping like: (10 times like this)
TCP 3095 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3096 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3097 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3098 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3099 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3100 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3101 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3102 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3103 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3104 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3105 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3106 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3107 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3108 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3109 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3110 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3111 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3112 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3113 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3114 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3115 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3116 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3117 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3118 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3119 192.168.2.2 TIME WAIT 192.168.2.2:1433
any clue?
regards|||I have the same problem, sp_who only shows < 50 connections. Any other ideas
please?

connection error after 15 minutes of restart

Connection error 40

Hi,
I developed a programm with dot.net 2.0.
On my environment ervy thing works fine.
When I try to use it on the customers envrionment I get the following error
message:
"An error has occured while establishing a connection to the server.
When connecting to SQL Server 2005, this failuer may be cused by the fact
that under the default settings SQL Server does not allow remote connections
(provider Named Pipes Provider, error 40 Could not open a connection to SQL
Server)"
I want to get connect to an SQL 2000 server. Named Pipes and TCP/IP are
enabled on the server.
I use the following connection String:
"Server=server.domain.com; Initial Catalog=database.mdf;;Integrated
Security=False;Connect Timeout=30;Password=password; UID=user"
How can I solve this problem?
TIA
Marcus MngelCheck your connection string, it doesn't look right. I've never seen the
keys "UID" and "Password" used in the same connection string, and unless
you're using Express Edition, you dont need .mdf on the end of your DB name.
Check out this site for help on your connection string:
http://www.connectionstrings.com/
My guess is it should look something like this:
"Server=server.domain.com;Database=database;User ID=user;Password=password;"
"Marcus Mngel" <nc-maengema@.netcologne.de> wrote in message
news:eht7n6$t4t$1@.newsreader2.netcologne.de...
> Hi,
> I developed a programm with dot.net 2.0.
> On my environment ervy thing works fine.
> When I try to use it on the customers envrionment I get the following
> error
> message:
> "An error has occured while establishing a connection to the server.
> When connecting to SQL Server 2005, this failuer may be cused by the fact
> that under the default settings SQL Server does not allow remote
> connections
> (provider Named Pipes Provider, error 40 Could not open a connection to
> SQL
> Server)"
> I want to get connect to an SQL 2000 server. Named Pipes and TCP/IP are
> enabled on the server.
> I use the following connection String:
> "Server=server.domain.com; Initial Catalog=database.mdf;;Integrated
> Security=False;Connect Timeout=30;Password=password; UID=user"
> How can I solve this problem?
> TIA
> Marcus Mngel
>
>

Connection Error 18452 - Login failed for user '(null)'

Hello everybody,
one of our users gets an error message when trying to connect to our SQL
Server database:
Connection failed:
SQLState: '28000'
SQL Server Error 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.
The problem occured suddenly during work. The user can connect to the server
using another computer and other users can connect using his computer.
Knowledge base didn't help so I'm asking you.
Configuration
Client: Windows XP professional (2002/SP1)
ODBC driver: SQL Server (2000.81.9042.00)
Client configuration: TCP/IP
Server: Windows 2000 Server
SQL Server 7.0
Seems the network setup for the user is somehow corrupted, since the message
states the user to be '(null)'.
Any suggestions?
Thanks in advance,
Markus Wolff
This is always an authentication problem somewhere. The null indicates that
user cannot be validated and a null is being passsed to SQL Server.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Rand, what about a solution or al least pointing to one?
"Rand Boyd [MSFT]" wrote:

> This is always an authentication problem somewhere. The null indicates that
> user cannot be validated and a null is being passsed to SQL Server.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
|||It really depends on where the process is failing. You would
want to check the event logs on the PC having the problems
connecting. Check for any network related issues or
problems. Make sure that PC is contacting the domain
controllers without any problems and that they are
successfully logging into the network.
-Sue
On Mon, 13 Dec 2004 08:25:02 -0800, "JC"
<JC@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Rand, what about a solution or al least pointing to one?
>"Rand Boyd [MSFT]" wrote:
|||Login failed for user <null> usually means that on the SQL box, the user
account could not be found in the local security database or in the domain
controller's user database.
For example, on machine1 I log in as machine1\user1. Then I try to log into
SQL on machine2. On machine2 SQL takes the SID of the user and calls
LookupAccountSID API. This attempts to convert the SID to the user name.
LookupAccountSID first looks in local security database on machine2, and
does not find machine1\User1, then looks on domain controller, and still
does not find the SID.
So in general this points to problems with the user account. Perhaps the
user has the same account name defined on their local machine and when they
log in they don't realize that they are logging in as the local User1 versus
the domain User1. Go to the problematic machine and check the user
accounts. If this does not work, perhaps have the domain admin drop the
user account and recreate it.
Matt
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:jd4sr0ds5vna1pc5ph4ri66j5hmri6d51p@.4ax.com...
> It really depends on where the process is failing. You would
> want to check the event logs on the PC having the problems
> connecting. Check for any network related issues or
> problems. Make sure that PC is contacting the domain
> controllers without any problems and that they are
> successfully logging into the network.
> -Sue
> On Mon, 13 Dec 2004 08:25:02 -0800, "JC"
> <JC@.discussions.microsoft.com> wrote:
>

Connection Error 18452 - Login failed for user '(null)'

Hello everybody,
one of our users gets an error message when trying to connect to our SQL
Server database:
Connection failed:
SQLState: '28000'
SQL Server Error 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user
'(null)'. Reason: Not associated with a trusted SQL Server connection.
The problem occured suddenly during work. The user can connect to the server
using another computer and other users can connect using his computer.
Knowledge base didn't help so I'm asking you.
Configuration
Client: Windows XP professional (2002/SP1)
ODBC driver: SQL Server (2000.81.9042.00)
Client configuration: TCP/IP
Server: Windows 2000 Server
SQL Server 7.0
Seems the network setup for the user is somehow corrupted, since the message
states the user to be '(null)'.
Any suggestions?
Thanks in advance,
Markus WolffThis is always an authentication problem somewhere. The null indicates that
user cannot be validated and a null is being passsed to SQL Server.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Rand, what about a solution or al least pointing to one?
"Rand Boyd [MSFT]" wrote:

> This is always an authentication problem somewhere. The null indicates tha
t
> user cannot be validated and a null is being passsed to SQL Server.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>|||It really depends on where the process is failing. You would
want to check the event logs on the PC having the problems
connecting. Check for any network related issues or
problems. Make sure that PC is contacting the domain
controllers without any problems and that they are
successfully logging into the network.
-Sue
On Mon, 13 Dec 2004 08:25:02 -0800, "JC"
<JC@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Rand, what about a solution or al least pointing to one?
>"Rand Boyd [MSFT]" wrote:
>|||Login failed for user <null> usually means that on the SQL box, the user
account could not be found in the local security database or in the domain
controller's user database.
For example, on machine1 I log in as machine1\user1. Then I try to log into
SQL on machine2. On machine2 SQL takes the SID of the user and calls
LookupAccountSID API. This attempts to convert the SID to the user name.
LookupAccountSID first looks in local security database on machine2, and
does not find machine1\User1, then looks on domain controller, and still
does not find the SID.
So in general this points to problems with the user account. Perhaps the
user has the same account name defined on their local machine and when they
log in they don't realize that they are logging in as the local User1 versus
the domain User1. Go to the problematic machine and check the user
accounts. If this does not work, perhaps have the domain admin drop the
user account and recreate it.
Matt
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:jd4sr0ds5vna1pc5ph4ri66j5hmri6d51p@.
4ax.com...
> It really depends on where the process is failing. You would
> want to check the event logs on the PC having the problems
> connecting. Check for any network related issues or
> problems. Make sure that PC is contacting the domain
> controllers without any problems and that they are
> successfully logging into the network.
> -Sue
> On Mon, 13 Dec 2004 08:25:02 -0800, "JC"
> <JC@.discussions.microsoft.com> wrote:
>
>

Connection Error 18452 - Login failed for user '(null)'

Connection error : SQL Server does not exist or access denied

hello , i'm very new to sql server.

i'm using sql server 200 & winXP. I have a local server called "JO" and a dsn named "LocalServer".

Authentication is sql server authentication & window with username of "cying" and password "admin"

i can ping my server "JO" but cannot telnet it's sql_server_tcp_port.

this is the error code i obtained when try to open the connection:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

my connection string is as below :

set objcon = server.CreateObject("ADODB.Connection")

strConnection = "Provider=MSDASQL;Driver={SQL Server};Server=local;Data Source=LocalServer;User ID=cying;Password=admin;Persist Security Info=False"

objcon.open, strConnection

is there anything wrong with my connection string or setting?

pls help, thanks in advance

ok, i can now connect to sql server but another error occurs:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Provider=MSDASQL'.

my connection string is as below :

strConnection = "Provider=MSDASQL;Driver={SQL Server};Server=(local);User ID=cying;Password=admin;Persist Security Info=False;"

do i need to put in data source? i created the user id under enterprise manager, (local) > serucity > logins. server access is set to permit. i even try log in with sa account but still comes out the same error.

pls help, thank u

|||

Hi,

It looks like you're running into a known problem described in the BOL (http://msdn2.microsoft.com/en-us/library/ms190204.aspx):

Note:

To enhance security, SQL Server 2005 disables TCP/IP connectivity to SQL Server 2005 for new installations of the Developer, Evaluation, and SQL Server Express editions. OLEDB applications connecting with MDAC 2.8 cannot connect to the default instance on local server using ".", "(local)", or (<blank>) as the server name. To resolve this, supply the server name, or enable TCP/IP on the server. Connections to local named instances are not affected, and connections using SQL Native Client are not affected. Installations where a previous installation of SQL Server is present might not be affected.

Try changing "(local)" to the name of the server.

Il-Sung.

|||

i manage to connect to db finally after changing the code, here's my new connection string

strConn = "Provider=MSDASQL;Driver={SQL Server};server=(local);uid=cying;pwd=admin;database=cying"

II-Sung, i'm using sql server 2000 and hav TCP/IP enabled

i think the cause of problem is uid & pwd, previously i used user name & password and failed to establish a connection

thanks for ur help though =)

Connection error ( from MS Analysis to Applix TM1)

Hi All,

I am trying to connect from MS Analysis Services 2000 to Applix TM1.
Applix has got Applix OLE DB MD Prodiver.It is installed on my machine.
I create a datasource in MSAS.
In Data Link I can see the this Applix OLE DD driver and I choose it. Then I can see Applix login and password screen. Then I logged in. When I test my connection, the connection is succeed.
But when I create a cube from data source,it gets an error message as below;

Connection teamnb-cem data source failed.
Object or provider is not capable of performing requested operation
Do you want to retry_?

How can I fix it?

BEst Regards

Cem DAGLI

AS2000 has list of supported providers, and TM1 is not one of them. There are many requirements for OLEDB provider to work properly with AS2000, so I am not optimistic you will succeed with this kind of direct connection. I suggest exporting data from TM1 cube into SQL Server first, and then processing AS2000 cube off SQL Server.|||

Dear Mosha,

I am using Applix OLE DB MD Provider. Not Microsoft providers.
When you install Applix , you have Applix OLE DB MD provider. I connected from Excel to Applix TM1.
But for AS2000 not.

Does AS2005 support Applix OLE DB MD Provider? If I try it from MSAS 2005 ,can I connect it?

Best Regards
Cem dAGLI

|||So, what exactly do you mean when you say "Connect AS2000 to Applix". The only way AS2000 "connects" to external databases is for processing or ROLAP, and there is a list of supported providers (SQL Server, Oracle etc) - Applix is not on that list.|||

Dear Mosha,

I mean connect from MSAS 2000 to Applix TM1 OLAP Server.

There is a Applix OLE DB MD Provider in Data Link screen in MSAS 2000. The Driver is provided by Applix.
I also connected from MS Excel to Applix OLAP server with this driver.
If you send me your e-mail , I will send all printed screen in MSAS 2000.

Best Regards

Cem DAGLI

|||

Cem

Unfortunately, you don't make yourself clear - you just repeated the information that you already provided earlier. The only way the statement "connect MSAS 2000 to Applix TM1 OLAP Server" can be interpreted is that you try to process MSAS cube out of the TM1 cube, and use Applix OLEDB provider for that. As I explained above - this is not supported scenario. If you have some clarifying screenshots - please attach them to this post.

|||

Hi Mosha,

I need to extract some data from Applix TM1 cubes into MS SQL Server. Here are the steps i tried to create a connection in MS SQL 2000 DTS package using Applix TM1 OLE DB MD Provider (v8.4.2).

1) Create a new DTS package
2) Add Connection Properties. Applix TM1 OLE DB MD Provider is not listed in the 'Data Source' list. So i choose Microsoft OLE DB Provider for OLAP Services 8.0

3) Click Properties...

4) On Provider tab, choose Applix TM1 OLE DB MD Provider.

5) On Connection tab, specify the TM1 server location & instance. Test Connection is successful.

6) Click OK to complete the configuration.

When i edit the connection properties again, the provider reverts to Micosoft OLMicrosoft OLE DB Provider for OLAP Services 8.0. It doesn't seem to save the configuration done above.

Could you please shed some lights on how to get this to work? Thanks a lot.

Connection error - please help

I'm setting up a development environment on XP Pro. I'm working with classi
c
ASP. IIS is working great, but when trying to connect to my SQL Server
Database, I get:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.
I've checked and re-checked both the name of the database and server, plus
everything looks configured correctly in Enterprise Manager (SQL server and
Windows is checked).
In ODBC, after I configure my System DSN, I test it and it connects
correctly. But this dang error persists. I'm at my wits end with it all,
can you help?
Any comments would be very very appreciated.
Thank you.Try making a network trace from the IIS machine to SQL and review the
traffic.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Why IIS machine, what is the relation between IIS and SQL
server here? What kind of trace should I do, can you
explain it in a simple way.
Thanks a lot-Rob

>--Original Message--
>Try making a network trace from the IIS machine to SQL
and review the
>traffic.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||IIS is the client to SQL. I"m asuming that they are two different machines.
client -->IIS-->SQL
IIS is opening and closing all the connection to SQL, not the client
browser. So, making a network trace from IIS will show the traffic to the
server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I have the same problem. Help.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...

Connection error - please help

I'm setting up a development environment on XP Pro. I'm working with classic
ASP. IIS is working great, but when trying to connect to my SQL Server
Database, I get:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
I've checked and re-checked both the name of the database and server, plus
everything looks configured correctly in Enterprise Manager (SQL server and
Windows is checked).
In ODBC, after I configure my System DSN, I test it and it connects
correctly. But this dang error persists. I'm at my wits end with it all,
can you help?
Any comments would be very very appreciated.
Thank you.
Try making a network trace from the IIS machine to SQL and review the
traffic.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Why IIS machine, what is the relation between IIS and SQL
server here? What kind of trace should I do, can you
explain it in a simple way.
Thanks a lot-Rob

>--Original Message--
>Try making a network trace from the IIS machine to SQL
and review the
>traffic.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>
|||IIS is the client to SQL. I"m asuming that they are two different machines.
client -->IIS-->SQL
IIS is opening and closing all the connection to SQL, not the client
browser. So, making a network trace from IIS will show the traffic to the
server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||I have the same problem. Help.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

connection error

hi,

I installed sql server 2005 ,when i try to connect to sql server management studio iam getting this error.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

I searched internet and found this :under sql server surface area configuration

So I followed the following steps to change the setting from local connection to local and remote connection:

1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration. 2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections. 3. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.

Note Click OK when you receive the following message:

Changes to Connection Settings will not take effect until you restart the Database Engine service.

4. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

But there is no DATABASE ENGINE It contain ANALYSIS SERVICES.

Then How Get rid from the above error.

Thanks in advance.

hi,

I installed sql server 2005 ,when i try to connect to sql server management studio iam getting this error.

I searched internet and found this :under sql server surface area configuration

So I followed the following steps to change the setting from local connection to local and remote connection:

Note Click OK when you receive the following message:

Changes to Connection Settings will not take effect until you restart the Database Engine service.

But there is no DATABASE ENGINE It contain ANALYSIS SERVICES.

Then How Get rid from the above error.

Thanks in advance.

|||

Look in the SCM (service Control manager of Windows) There you will find the SQL Server Service "SQL Server (MSSQLSERVER)" (or probably and instance name in the parenth.) Restart this service and you′ll be fine.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

connection error

I am getting following error while connecting in sql server. i have already disabled firewall, enabled remote connections using pipe and tcp and made sure the sql server and sql browser services are running.

but still the problem persists...can any help me ?

Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

thanks in advance

Do you have a named instacne or a default one ? how are you connecting, you will have to provide some more information on your situation to make it easier forus to give you the right suggestions.

Jens K. Suessmeyer

http://www.sqlserver2005.de

Connection Error

Good moorning, I am testing with a MSDE and ASP.NET, comment on you a bit:
- from the Server 1 connects with MSDE server without any problem, and it is
possible to operate on without problem.
- from the Server 2 and 3 it does not connect, does not open the connection,
and gives me the following mistake:
" The server SQL Server does not exist or the access has been refused "
The only thing that I am trying to do is an Open.
The connection is throught of Internet, that is to say, to a remote IP for a
different port, but I do not deal because if from one it works from other
two not.
It does not have integrated safety.
Thank you very much for everything
Hi,can you post your connectionstring to verify that you didnt do something
like (local) or 127.0.0.1 in that which evtl. dont existson the other
servers ?!
Thanks, Jens Suessmeyer.
http://www.sqlserver2005.de
"David - SICO SL" <sicosl@.community.nospam> schrieb im Newsbeitrag
news:OSRRtG5VFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Good moorning, I am testing with a MSDE and ASP.NET, comment on you a bit:
> - from the Server 1 connects with MSDE server without any problem, and it
> is possible to operate on without problem.
> - from the Server 2 and 3 it does not connect, does not open the
> connection, and gives me the following mistake:
> " The server SQL Server does not exist or the access has been refused "
>
> The only thing that I am trying to do is an Open.
> The connection is throught of Internet, that is to say, to a remote IP for
> a different port, but I do not deal because if from one it works from
> other two not.
> It does not have integrated safety.
> Thank you very much for everything
>
|||my connectionstring is:
workstation id=WEBSERVER;packet size=4096;user id=USER;data
source=80.32.XXX.XXX,1700;persist security info=false;initial
catalog=NAMEBD;password=PASS
and the webservers are in other locations, with other public IP
Thanks.
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> escribi
en el mensaje news:OynIV95VFHA.3488@.TK2MSFTNGP10.phx.gbl...
> Hi,can you post your connectionstring to verify that you didnt do
something[vbcol=seagreen]
> like (local) or 127.0.0.1 in that which evtl. dont existson the other
> servers ?!
> Thanks, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "David - SICO SL" <sicosl@.community.nospam> schrieb im Newsbeitrag
> news:OSRRtG5VFHA.1384@.TK2MSFTNGP09.phx.gbl...
bit:[vbcol=seagreen]
it[vbcol=seagreen]
for
>
|||"David" <sicosl@.community.nospam> schrieb im Newsbeitrag
news:udx4nt6VFHA.2572@.TK2MSFTNGP14.phx.gbl...
> my connectionstring is:
> workstation id=WEBSERVER;packet size=4096;user id=USER;data
> source=80.32.XXX.XXX,1700;persist security info=false;initial
> catalog=NAMEBD;password=PASS
> and the webservers are in other locations, with other public IP
> Thanks.
>
> "Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de>
> escribi
> en el mensaje news:OynIV95VFHA.3488@.TK2MSFTNGP10.phx.gbl...
> something
> bit:
> it
> for
>
|||Seems to me that this a network problem, the other Webservers cant reach
you data source from their location on port 1700, did you try to figure that
out ? Perhpas with a network monitoring or portscanning tool ?
"David" <sicosl@.community.nospam> schrieb im Newsbeitrag
news:udx4nt6VFHA.2572@.TK2MSFTNGP14.phx.gbl...
> my connectionstring is:
> workstation id=WEBSERVER;packet size=4096;user id=USER;data
> source=80.32.XXX.XXX,1700;persist security info=false;initial
> catalog=NAMEBD;password=PASS
> and the webservers are in other locations, with other public IP
> Thanks.
>
> "Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de>
> escribi
> en el mensaje news:OynIV95VFHA.3488@.TK2MSFTNGP10.phx.gbl...
> something
> bit:
> it
> for
>

Connection Error

Hi
I have a VB6 program that talks to SQL Server 2000 database. The Connection
String is as below:
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME &
";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source="
& M_SERVER
When the program is idle for a while, the connection terminates.
Also, when I try to connect using ODBC I get the following error
Connection failed;.
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect())
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
Any ideas or suggestions. Dont know where to start looking.
The SQL Server is running. I have double-checked that.
Please HELP
Thanks
Hi, Raju
See:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/827422
Razvan
|||I also have this same error. Did you find the solution?
I searched the entire net but couldnt find a solution.
If you try disabling and enabling the network connection, it will work again. Very strange.
Please do post if you got solution.
Thanks in advance to anybody who can help in this matter
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||trest
"Razvan Socol" <rsocol@.gmail.com> schrieb im Newsbeitrag
news:1132744113.256414.11460@.g43g2000cwa.googlegro ups.com...
> Hi, Raju
> See:
> http://support.microsoft.com/kb/328306
> http://support.microsoft.com/kb/827422
> Razvan
>

Connection error

connection error

Hello,
We just add a new SQL2000 server (SQL-3, 192.168.100.3) w/SP4 installed.
We have old SQL-1(192.168.100.1) and SQL-2(192.168.100.2) servers.
All 3 servers are in same location.
SQL-1 and SQL-2 are in same domain, i.e. domain-a.
SQL-3 is another domain, i.e. domain-b.
SQL-3 can add SQL-1 and SQL-2 from 'New SQL Server Registration'.
(We did not add SQL-1 and SQL-2 on 'Client Network Utility')
But SQL-1 or SQL-2 can not add SQL-3 from 'New SQL Server Registration'.
We use 'Client Network Utility' add alias with TCP/IP 192.168.100.3 and port
1433.
Then we have the message 'SQL Server does not exist or access denied
connection open (Connect[])' during add SQL-3 from 'New SQL Server
Registration'.
SQL-3's 'Allow other SQL Server to connect remotelly to this SQL Server
using RPC' is checked.
Thanks
Hi
This could be a firewall issue or you may be using dynamic ports (if this is
a named instance for example). Have you checked which port SQL3 is listening
on? Can you telnet on the given port to SQL3 from the other servers? Have you
tried using IP addresses instead of DNS Names?
You may want to check out SQLPing at
http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx
Also check the client protocols being used your service pack would indicate
TCP/IP should be first.
John
"Newbie" wrote:

> Hello,
> We just add a new SQL2000 server (SQL-3, 192.168.100.3) w/SP4 installed.
> We have old SQL-1(192.168.100.1) and SQL-2(192.168.100.2) servers.
> All 3 servers are in same location.
> SQL-1 and SQL-2 are in same domain, i.e. domain-a.
> SQL-3 is another domain, i.e. domain-b.
> SQL-3 can add SQL-1 and SQL-2 from 'New SQL Server Registration'.
> (We did not add SQL-1 and SQL-2 on 'Client Network Utility')
> But SQL-1 or SQL-2 can not add SQL-3 from 'New SQL Server Registration'.
> We use 'Client Network Utility' add alias with TCP/IP 192.168.100.3 and port
> 1433.
> Then we have the message 'SQL Server does not exist or access denied
> connection open (Connect[])' during add SQL-3 from 'New SQL Server
> Registration'.
> SQL-3's 'Allow other SQL Server to connect remotelly to this SQL Server
> using RPC' is checked.
> Thanks

Connection error

S1000 [Microsoft][ODBC SQL Server Driver]Connection is busy with results for
another hstmt
How to resolve this error.
Hi
Not much to go on, so look at
http://groups.google.ch/groups?q=Con...r=&sa=N&tab=wg and see if anything there solves your problem.
When you post, please post more information as errors like this can be
cuased by many problems.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Geeta" wrote:

> S1000 [Microsoft][ODBC SQL Server Driver]Connection is busy with results for
> another hstmt
> How to resolve this error.
|||Hi Mike,
The links given by you were of great help. I was using the same
connection object for multiple threads. I used a new connection object and
the issue is now resolved.
Thanks
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Not much to go on, so look at
> http://groups.google.ch/groups?q=Con...r=&sa=N&tab=wg and see if anything there solves your problem.
> When you post, please post more information as errors like this can be
> cuased by many problems.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Geeta" wrote:

Connection Error

Connection error

Hello......
I have a weird thing going on, I can see my server through the manager(Enterprise) but when I try to access it a warning comes up
A connection could not be established to (Server Name)
Reason: Cannot generate SSPI context.
Please verify SQL Server is running and check your SQL Server registration properties.
I have access to all my other servers using the same authentication (Windows). Any ideas?
Robert,
HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message
http://support.microsoft.com/default.aspx?id=811889
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"robert salazar" <rsalazar@.cbbank.com> wrote in message
news:6E0CB220-31C2-44F7-A797-45A0C37804DE@.microsoft.com...
> Hello......
> I have a weird thing going on, I can see my server through the
manager(Enterprise) but when I try to access it a warning comes up
> A connection could not be established to (Server Name)
> Reason: Cannot generate SSPI context.
> Please verify SQL Server is running and check your SQL Server registration
properties.
> I have access to all my other servers using the same authentication
(Windows). Any ideas?

Connection Error

Hi friends ! , you may help me with this...

I have a report made with CR 8.0 that I call from VB6 application with a CrystalReport Control. When I execute myCrystalReport.Action = 0, an error raises: error number 20536, description: not possible to begin session in the server.
The report takes the data from a table in a Sql Server.

This is the code:

CR.ReportFileName = gstrPathReports & "\People.rpt"
CR.Action = 0

I also tried with:

CR.LogOnServer "P2SSQL.DLL", gstrCfgServerName & "\" & gstrCfgInstanceName, _
gstrCfgDBName, "sa", "hello"

but it still odesn't work...

Thanks for your help !Hi try the following
CR.ReportFileName = gstrPathReports & "\People.rpt"
CR.Action = 1
Madhivanan|||Now it says: "Cannot open the sql server"

Any other idea?

By the way, what's the difference between 0 and 1 in the Action?

Thanks !!!|||so its the problem of connection..not the printing.
Have you tried showing the report like Report.Show without passing the parameters for printing?
The problem with the connection may be due that, you are not passing correct user name and password in the parameters.
And secondly that the report ypu are not setting database location.

You can check for parameters in the sql server profiler, if the query is fine and checking the query in the query analyzer.|||My CrystalReport control doesn't have the Show method...

The password and username are ok, and the database location is also ok, because when I open the report from Seagate Crystal Report 8.0 it works fine.

The report doesn't have parameters, because it just shows columns from a table.

That's why I tried with LogOnServer, because the problem seems to be that I can't open the connection from the VB6 application when I invoke the report, but still doesn't work...

Thank you for any ideas !|||does your report have subreports?|||No, it doesn't...|||Hi vbUsername, check whether gstrCfgServerName & "\" & gstrCfgInstanceName gives correct server name that you are using.

Madhivanan|||Yes, they are ok, as well as the DBName, UID and PWD...

Thank you for your concern !
I just cannot make it work, and it's such a simple report !

Connection Error

Connection error

Hi,
I get the following error when I try to connect to SQL 2005 Beta from VS 2005.
"A connection was successfully established with the server, but then an
error occurred during the login process. (provider: TCP Provider, error: 0 -
An existing connection was forcibly closed by the remote host.) "
The calling page "Default.aspx" only has a GridView control.
Help please!!!"Mumbai_Chef" <MumbaiChef@.discussions.microsoft.com> wrote in message
news:84F879BA-F54F-420C-8576-0CACE17AB39B@.microsoft.com...
> Hi,
> I get the following error when I try to connect to SQL 2005 Beta from VS
> 2005.
> "A connection was successfully established with the server, but then an
> error occurred during the login process. (provider: TCP Provider, error:
> 0 -
> An existing connection was forcibly closed by the remote host.) "
> The calling page "Default.aspx" only has a GridView control.
> Help please!!!
Does the 2005 beta have an expiration date?
Rick Sawtell
MCT, MCSD, MCDBA|||Rick,
No I don't think so. I can see the data when i do "Test query" from the
GridView control on the page. My team member can run the app without any
errors.
Thanks
Mumbai_Chef
"Rick Sawtell" wrote:
> "Mumbai_Chef" <MumbaiChef@.discussions.microsoft.com> wrote in message
> news:84F879BA-F54F-420C-8576-0CACE17AB39B@.microsoft.com...
> > Hi,
> >
> > I get the following error when I try to connect to SQL 2005 Beta from VS
> > 2005.
> >
> > "A connection was successfully established with the server, but then an
> > error occurred during the login process. (provider: TCP Provider, error:
> > 0 -
> > An existing connection was forcibly closed by the remote host.) "
> >
> > The calling page "Default.aspx" only has a GridView control.
> >
> > Help please!!!
> Does the 2005 beta have an expiration date?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||I've generally seen the "Forcibly Closed" error when the Windows firewall in
XP was blocking the connection but I assume there are other things that
could cause this. Can the same user connect with sqlcmd?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Mumbai_Chef" <MumbaiChef@.discussions.microsoft.com> wrote in message
news:35E74F79-80C0-4E84-B9AC-2BF569701E59@.microsoft.com...
> Rick,
> No I don't think so. I can see the data when i do "Test query" from the
> GridView control on the page. My team member can run the app without any
> errors.
> Thanks
> Mumbai_Chef
>
> "Rick Sawtell" wrote:
>> "Mumbai_Chef" <MumbaiChef@.discussions.microsoft.com> wrote in message
>> news:84F879BA-F54F-420C-8576-0CACE17AB39B@.microsoft.com...
>> > Hi,
>> >
>> > I get the following error when I try to connect to SQL 2005 Beta from
>> > VS
>> > 2005.
>> >
>> > "A connection was successfully established with the server, but then an
>> > error occurred during the login process. (provider: TCP Provider,
>> > error:
>> > 0 -
>> > An existing connection was forcibly closed by the remote host.) "
>> >
>> > The calling page "Default.aspx" only has a GridView control.
>> >
>> > Help please!!!
>> Does the 2005 beta have an expiration date?
>>
>> Rick Sawtell
>> MCT, MCSD, MCDBA
>>
>>|||If the issue is with the firewall than how can another user logged in from my
machine can access the data without any error. I am out of ideas.
Thanks
"Roger Wolter[MSFT]" wrote:
> I've generally seen the "Forcibly Closed" error when the Windows firewall in
> XP was blocking the connection but I assume there are other things that
> could cause this. Can the same user connect with sqlcmd?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Mumbai_Chef" <MumbaiChef@.discussions.microsoft.com> wrote in message
> news:35E74F79-80C0-4E84-B9AC-2BF569701E59@.microsoft.com...
> > Rick,
> > No I don't think so. I can see the data when i do "Test query" from the
> > GridView control on the page. My team member can run the app without any
> > errors.
> >
> > Thanks
> > Mumbai_Chef
> >
> >
> > "Rick Sawtell" wrote:
> >
> >>
> >> "Mumbai_Chef" <MumbaiChef@.discussions.microsoft.com> wrote in message
> >> news:84F879BA-F54F-420C-8576-0CACE17AB39B@.microsoft.com...
> >> > Hi,
> >> >
> >> > I get the following error when I try to connect to SQL 2005 Beta from
> >> > VS
> >> > 2005.
> >> >
> >> > "A connection was successfully established with the server, but then an
> >> > error occurred during the login process. (provider: TCP Provider,
> >> > error:
> >> > 0 -
> >> > An existing connection was forcibly closed by the remote host.) "
> >> >
> >> > The calling page "Default.aspx" only has a GridView control.
> >> >
> >> > Help please!!!
> >>
> >> Does the 2005 beta have an expiration date?
> >>
> >>
> >> Rick Sawtell
> >> MCT, MCSD, MCDBA
> >>
> >>
> >>
> >>
>
>

Connection error

Hello.....
I have a weird thing going on, I can see my server through the manager(Enterprise) but when I try to access it a warning comes up
A connection could not be established to (Server Name
Reason: Cannot generate SSPI context
Please verify SQL Server is running and check your SQL Server registration properties
I have access to all my other servers using the same authentication (Windows). Any ideas?Robert,
HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message
http://support.microsoft.com/default.aspx?id=811889
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"robert salazar" <rsalazar@.cbbank.com> wrote in message
news:6E0CB220-31C2-44F7-A797-45A0C37804DE@.microsoft.com...
> Hello......
> I have a weird thing going on, I can see my server through the
manager(Enterprise) but when I try to access it a warning comes up
> A connection could not be established to (Server Name)
> Reason: Cannot generate SSPI context.
> Please verify SQL Server is running and check your SQL Server registration
properties.
> I have access to all my other servers using the same authentication
(Windows). Any ideas?

Connection error

S1000 [Microsoft][ODBC SQL Server Driver]Connection is busy with res
ults for
another hstmt
How to resolve this error.Hi
Not much to go on, so look at
http://groups.google.ch/groups? q=C...lr=&sa=N&tab=wg and see if anything there solves your problem.
When you post, please post more information as errors like this can be
cuased by many problems.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Geeta" wrote:

> S1000 [Microsoft][ODBC SQL Server Driver]Connection is busy with r
esults for
> another hstmt
> How to resolve this error.|||Hi Mike,
The links given by you were of great help. I was using the same
connection object for multiple threads. I used a new connection object and
the issue is now resolved.
Thanks
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Not much to go on, so look at
> http://groups.google.ch/groups? q=C...lr=&sa=N&tab=wg and see if anything there solves your problem.
> When you post, please post more information as errors like this can be
> cuased by many problems.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Geeta" wrote:
>

Connection error

Hello......
I have a weird thing going on, I can see my server through the manager(Enter
prise) but when I try to access it a warning comes up
A connection could not be established to (Server Name)
Reason: Cannot generate SSPI context.
Please verify SQL Server is running and check your SQL Server registration p
roperties.
I have access to all my other servers using the same authentication (Windows
). Any ideas?Robert,
HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message
http://support.microsoft.com/default.aspx?id=811889
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"robert salazar" <rsalazar@.cbbank.com> wrote in message
news:6E0CB220-31C2-44F7-A797-45A0C37804DE@.microsoft.com...
> Hello......
> I have a weird thing going on, I can see my server through the
manager(Enterprise) but when I try to access it a warning comes up
> A connection could not be established to (Server Name)
> Reason: Cannot generate SSPI context.
> Please verify SQL Server is running and check your SQL Server registration
properties.
> I have access to all my other servers using the same authentication
(Windows). Any ideas?

connection error

Hello,
We just add a new SQL2000 server (SQL-3, 192.168.100.3) w/SP4 installed.
We have old SQL-1(192.168.100.1) and SQL-2(192.168.100.2) servers.
All 3 servers are in same location.
SQL-1 and SQL-2 are in same domain, i.e. domain-a.
SQL-3 is another domain, i.e. domain-b.
SQL-3 can add SQL-1 and SQL-2 from 'New SQL Server Registration'.
(We did not add SQL-1 and SQL-2 on 'Client Network Utility')
But SQL-1 or SQL-2 can not add SQL-3 from 'New SQL Server Registration'.
We use 'Client Network Utility' add alias with TCP/IP 192.168.100.3 and port
1433.
Then we have the message 'SQL Server does not exist or access denied
connection open (Connect[])' during add SQL-3 from 'New SQL Server
Registration'.
SQL-3's 'Allow other SQL Server to connect remotelly to this SQL Server
using RPC' is checked.
ThanksHi
This could be a firewall issue or you may be using dynamic ports (if this is
a named instance for example). Have you checked which port SQL3 is listening
on? Can you telnet on the given port to SQL3 from the other servers? Have yo
u
tried using IP addresses instead of DNS Names?
You may want to check out SQLPing at
http://www.sqlsecurity.com/Tools/Fr...65/Default.aspx
Also check the client protocols being used your service pack would indicate
TCP/IP should be first.
John
"Newbie" wrote:

> Hello,
> We just add a new SQL2000 server (SQL-3, 192.168.100.3) w/SP4 installed.
> We have old SQL-1(192.168.100.1) and SQL-2(192.168.100.2) servers.
> All 3 servers are in same location.
> SQL-1 and SQL-2 are in same domain, i.e. domain-a.
> SQL-3 is another domain, i.e. domain-b.
> SQL-3 can add SQL-1 and SQL-2 from 'New SQL Server Registration'.
> (We did not add SQL-1 and SQL-2 on 'Client Network Utility')
> But SQL-1 or SQL-2 can not add SQL-3 from 'New SQL Server Registration'.
> We use 'Client Network Utility' add alias with TCP/IP 192.168.100.3 and po
rt
> 1433.
> Then we have the message 'SQL Server does not exist or access denied
> connection open (Connect[])' during add SQL-3 from 'New SQL Server
> Registration'.
> SQL-3's 'Allow other SQL Server to connect remotelly to this SQL Server
> using RPC' is checked.
> Thanks

Connection Error

connection error

Hello freinds,

i want to copy my bulk files to database using dts.bulkinsert function.For that i need to activate MS Distributed Transatction Coordinator.But whwn i am activating this i am getting [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. error. can anyone please suggest me whats d problem exactly and hoe can i remove it.:confused:Hi,

Please check whether the services are started or not.

If not open service manager and start the services.

Regards,
Shashidhar

Connection Error

Hi,

I have developed a program which connects to an SQL Express 2005 server. This worked fine until yesterday when the server failed. I have set up a new server, same name, config, etc and restored the data back into the database.

When the program runs it displays an error:

System.Runtime.InteropServices.COMException (0x800A0E7D): The connection cannot be used to perform this operation. It is either closed or invalid in this context.

Connection code that is erroring:

rs.Open(s, sq, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic)

* s is the search string

* sq is the connection string

sq.open("Provider=SQOLEDB;Data Source=mns-web01\sqlexpress;User ID=WLANClient;Password=password;Initial Catalog=WLAN;")

It also has a 'ghost' user which cannot be removed or re-created. This is the user which the code uses to connect to the database.

Any ideas?

Thanks

Sounds like somewhere in your code you closed or destroyed the connection, and tried to initiate an action after that. Create a simple connection test section of code with a simple select, and then try layering your other code back in. This happens a lot when you're doing looping or calling out to sub procedures.

Buck Woody

Connection error

Hi there,

I installed Visual Web Developer Express and SQL Server Express. I then installed the Time Tracker Starter Kit on my localhost. My instance of SQL Server Express is 'Express'. So I updated the root web.config file. I try out the app. by creating a new user and then get this error:

Exception Details:System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I'm using a HTTP connection port 7080 (ie,http://localhost:7080/TimeTracker/), does that mean I have to update anything in the app?

I was told to update SQL Server 2005 Surface Area Configuration - Remote Connections to Using both TCP/IP and named pipes. So I already did that and rebooted.

Any suggestions?

Post your connection string, it may help Smile

|||

Hey it works.

I noticed that I had to modify the database connnection under the database explorer, even though I had updated the web.config

Take care

Connection Error

What the problem of this error. For information, please check code as below,

ProtectedConst SQL_CONNECTION_STRINGAsString = "workstation id=LOCALHOST; size=4096;integrated security=SSPI;initial catalog=VIVAM;persist security info=False;User ID=sa"

below is the error command

Login failed for user 'BST-FAIROZ\ASPNET'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Login failed for user 'BST-FAIROZ\ASPNET'.

As you set integrated security to SSPI in connection string, you're using Windows Authentication to connnect to SQL. So when the application is deployed to IIS5.0, IIS will use'BST-FAIROZ\ASPNET'account to connect to SQL. So what you need to do is add the account in SQL logins: open Management Studio (or Enterprise Manager)-> locate local SQL instance->Security->Logins->New Login. And give sufficient permissions to the account so that your application can perform query to SQL as you like.

Saturday, February 25, 2012

What the problem of this error. For information, please check code as below,

Login failed for user 'BST-FAIROZ\ASPNET'.

Blog Archive

About Me