Alert on data lock

Hi,
Did somebody know if I can set an Email alert in SQL Server when some
connection is block by somebody else?
Thanks,
SylvieIt is difficult to setup an alert for this condition as no error will be
raised by default. With the default lock timeout the connection will just
continue to wiat, until it acquires the resource, or until the application
timeout comes into affect.
However, you can setup a stored procedure, to continually monitor sp_who
output, or master..sysprocesses table and send emails out, if you see
excessive blocking. You could send email from a stored procedure, using SQL
Mail or sp_smtp_sendmail. See SQL Server Books Online for more info on SQL
Mail. Check out sqldev.net for info on sp_smtp_sendmail.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Sylvie" <sylvie.mondoux@.fjordinteractif.com> wrote in message
news:eRo2xMlpEHA.536@.TK2MSFTNGP09.phx.gbl...
Hi,
Did somebody know if I can set an Email alert in SQL Server when some
connection is block by somebody else?
Thanks,
Sylviesql

Aggregation design wizard - A connection cannot be made. Ensure that the server is running ...

In my SSAS SP1, I received an error msg in Aggregation design wizard "A connection cannot be made. Ensure that the server is running ..." while I was tryng to start "Performance gain reaches%" box. I verified that the local source SQL 2005 sample "AdventureWorksDW" is running without a problem.

Make sure your Analysis Server is running.

Aggregation Design Wizard sends commands to Analysis Server that is running aggregation desing algorithm.

Try and open SQL Management Studio and make sure you can connect to Analysis Server.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

While I tried to connect to Analysis Server in SQL Management Studio, I got an error as following -
* I am sure the service of "SQL Server Analysis Services (MSSQLSERVER)" is started on port 2383.

Quotes:

TITLE: Connect to Server

Cannot connect to localhost.

ADDITIONAL INFORMATION:

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

DIME protocol error: The required bytes cannot be read from the stream. (Microsoft.AnalysisServices.AdomdClient)

BUTTONS:

OK

|||

Open Service control manager and make sure you've started "SQL Server Analysis Services( MSSQLSERVER)" service. That is in case you installed default instance.

If you installed named instance the service name will contain the instance name.

For troubleshooting connectivity issues you can look at some tips on http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks a lot.
I had carefully read your posted URL, but I had NOT found a way to solve the problem yet.
(1) In Service control manager, SQL Server Analysis Services (MSSQLSERVER) is started.
(2) In DOS command console, C:/>telnet localhost 2383 , output a blank screen, means that - port 2383 is on listening on localhost.
so that, I am SURE that
- SQL Server Analysis Services (MSSQLSERVER)" is started and listening on port 2383 -
but when I try to connect to Analysis Services in Microsoft SQL Server Management Studio , the error popup:

Frank X. Huang wrote:

TITLE: Connect to Server

Cannot connect to localhost.

ADDITIONAL INFORMATION:

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

DIME protocol error: The required bytes cannot be read from the stream. (Microsoft.AnalysisServices.AdomdClient)

BUTTONS:

OK

|||

Let's try another thing.

On your server machine:

Create a new text file in one of your folders.

Change the extension of the file from .txt to .udl. Doble click on the file and you'd see data link dialog open up.

Switch to the Provider tab and select "Microsoft OLEDB provider for Analysis Services 90"

Go to the Connection tab and type in the server name for the Data Source. Choose Windows auth.

At this moment you should be able to see list of databases on the server.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I do like this -

(1) on my server machine(localhost): create a new text file and rename to x.udl;
(2) Double click on the file, and In the popup window which titled "Data Link Properties",
(2.1) In "Provider" tab, I select "Microsoft OLE DB Provider for Analysis Services 9.0",
(2.2) In "Connection" tab, I select "Use Windows NT Integrated security"; Fill "Data Source:" textbox with "localhost"; let "Location:" textbox empty; and then
(2.2.1) if I drop down the list of "Enter the initial catalog to use:", there is an error "An error was encountered in the transport layer." with title "Microsoft Data Link Error".

(2.2.1.1) I have no choice but to click "OK" on the error window, and then another window shows "Login failed. Catalog information cannot be retrieved."
(2.2.2) or, if I click "Test Connection" button, an error show "Test connection failed because of an error in initializing provider. An error was encountered in the transport layer."

Further more, I try some other things -
(1) create a data source with "SQL Native Client"(version 2005.90.2047.00), and then retry all steps.
(2) at step 2.1, I select another Provider "SQL Native Client"(version 2005.90.2047.00); at step 2.2 fill the data source with "localhost"; and then "Test Connection"......It's OK!......or, drop down the database name list, It's OK!.......no error!

By the way, "Database Engine", "Integration Services", and "Reporting Services" are ALL can be connected, ONLY "Analysis Services" CANNOT be connected in the "Microsoft SQL Server Management Studio".

|||(1) I removed and re-installed Microsoft SQL Server 2005 Developer Edition on my Windows XP Professional, yet the error remains.
(2) I, then, downloaded and installed Microsoft SQL Server 2005 SP1, and try again, the error remains.
(3) I also remove and reinstall my Network Interface Card on my IBM ThinkPad, and start all services who can be started on my Operating System, the error remains.
Who can help me, God?|||

Another idea.

This could be a network related. Instead of localhost try to use machine name or IP of your server.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks God! I fixed this problem, but I really do not know how and why?

I will do some experiment and try to find it out (this may take me several hours or days or never), but now, I only list what I did -

(1) There is an error "Could not add the requested component.
The error is: ...."(sorry for lost details) when I try to install Microsoft TCP/IP version 6 on my Network Adapter;

(2) There is an error "Unable to start the MSMQ service. Error Code: 0x433
Error description: The dependency service does not exist or has been marked for deletion. "
and/or "Setup could not copy one or more files. The specific error code is 0x4b8..."
and/or "The MSMQTriggers service cannot be started. Error Code: 0x42C Error Description: The dependency service or group failed to start."
When I removed and try to re-install Message Queuing;

(3.1) To resolve 0x4b8, I running this command:
esentutl /p c:\WINDOWS\security\Database\secedit.sdb

(3.2) To resolve 0x42C, I found a very useful message on Etc. Windows.
http://www.google.com/notebook/public/04097591150171922613/BDT6NIgoQlMDj180h
and running these commands:

net stop msdtc

msdtc -uninstall

go into regedit and delete the key HKLM\Software\Microsoft\MSDTC

msdtc -install

net start msdtc

(3.3) Now, I can continue to re-install Message Queuing.

(4) Check and install Microsoft TCP/IP version 6.

(5) Connect to localhost (Analysis Server) in Microsoft SQL Server Management Studio. It is OK now!

I really don't know how to fixed but I finally fiexed it anyhow! If you doubt whether it meets your case or not, please just take a trial; If you want to contact me, please email to huangxiangyao@.hotmail.com.

|||

Thanks God! I fixed this problem, but I really do not know how and why.

I will do some experiment and try to find it out (this may take me several hours or days or never), but now, I only list what I did -

(1) There is an error "Could not add the requested component.
The error is: ...."(sorry for lost details) when I try to install Microsoft TCP/IP version 6 on my Network Adapter;

(2) There is an error "Unable to start the MSMQ service. Error Code: 0x433
Error description: The dependency service does not exist or has been marked for deletion. "
and/or "Setup could not copy one or more files. The specific error code is 0x4b8..."
and/or "The MSMQTriggers service cannot be started. Error Code: 0x42C Error Description: The dependency service or group failed to start."
When I removed and try to re-install Message Queuing;

(3.1) To resolve 0x4b8, I running this command:
esentutl /p c:\WINDOWS\security\Database\secedit.sdb

(3.2) To resolve 0x42C, I found a very useful message on Etc. Windows.
http://www.google.com/notebook/public/04097591150171922613/BDT6NIgoQlMDj180h
and running these commands:

net stop msdtc

msdtc -uninstall

go into regedit and delete the key HKLM\Software\Microsoft\MSDTC

msdtc -install

net start msdtc

(3.3) Now, I can continue to re-install Message Queuing.

(4) Check and install Microsoft TCP/IP version 6.

(5) Connect to localhost (Analysis Server) in Microsoft SQL Server Management Studio. It is OK now!

I really don't know how to fixed but I finally fiexed it anyhow! If you doubt whether it meets your case or not, please just take a trial; If you want to contact me, please email to huangxiangyao@.hotmail.com. (From 1:00 to 17:00 UTC)

Aggregation design wizard - A connection cannot be made. Ensure that the server is running .

In my SSAS SP1, I received an error msg in Aggregation design wizard "A connection cannot be made. Ensure that the server is running ..." while I was tryng to start "Performance gain reaches%" box. I verified that the local source SQL 2005 sample "AdventureWorksDW" is running without a problem.

Make sure your Analysis Server is running.

Aggregation Design Wizard sends commands to Analysis Server that is running aggregation desing algorithm.

Try and open SQL Management Studio and make sure you can connect to Analysis Server.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

While I tried to connect to Analysis Server in SQL Management Studio, I got an error as following -
* I am sure the service of "SQL Server Analysis Services (MSSQLSERVER)" is started on port 2383.

Quotes:

TITLE: Connect to Server

Cannot connect to localhost.

ADDITIONAL INFORMATION:

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

DIME protocol error: The required bytes cannot be read from the stream. (Microsoft.AnalysisServices.AdomdClient)

BUTTONS:

OK

|||

Open Service control manager and make sure you've started "SQL Server Analysis Services( MSSQLSERVER)" service. That is in case you installed default instance.

If you installed named instance the service name will contain the instance name.

For troubleshooting connectivity issues you can look at some tips on http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks a lot.
I had carefully read your posted URL, but I had NOT found a way to solve the problem yet.
(1) In Service control manager, SQL Server Analysis Services (MSSQLSERVER) is started.
(2) In DOS command console, C:/>telnet localhost 2383 , output a blank screen, means that - port 2383 is on listening on localhost.
so that, I am SURE that
- SQL Server Analysis Services (MSSQLSERVER)" is started and listening on port 2383 -
but when I try to connect to Analysis Services in Microsoft SQL Server Management Studio , the error popup:

Frank X. Huang wrote:

TITLE: Connect to Server

Cannot connect to localhost.

ADDITIONAL INFORMATION:

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

DIME protocol error: The required bytes cannot be read from the stream. (Microsoft.AnalysisServices.AdomdClient)

BUTTONS:

OK

|||

Let's try another thing.

On your server machine:

Create a new text file in one of your folders.

Change the extension of the file from .txt to .udl. Doble click on the file and you'd see data link dialog open up.

Switch to the Provider tab and select "Microsoft OLEDB provider for Analysis Services 90"

Go to the Connection tab and type in the server name for the Data Source. Choose Windows auth.

At this moment you should be able to see list of databases on the server.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I do like this -

(1) on my server machine(localhost): create a new text file and rename to x.udl;
(2) Double click on the file, and In the popup window which titled "Data Link Properties",
(2.1) In "Provider" tab, I select "Microsoft OLE DB Provider for Analysis Services 9.0",
(2.2) In "Connection" tab, I select "Use Windows NT Integrated security"; Fill "Data Source:" textbox with "localhost"; let "Location:" textbox empty; and then
(2.2.1) if I drop down the list of "Enter the initial catalog to use:", there is an error "An error was encountered in the transport layer." with title "Microsoft Data Link Error".

(2.2.1.1) I have no choice but to click "OK" on the error window, and then another window shows "Login failed. Catalog information cannot be retrieved."
(2.2.2) or, if I click "Test Connection" button, an error show "Test connection failed because of an error in initializing provider. An error was encountered in the transport layer."

Further more, I try some other things -
(1) create a data source with "SQL Native Client"(version 2005.90.2047.00), and then retry all steps.
(2) at step 2.1, I select another Provider "SQL Native Client"(version 2005.90.2047.00); at step 2.2 fill the data source with "localhost"; and then "Test Connection"......It's OK!......or, drop down the database name list, It's OK!.......no error!

By the way, "Database Engine", "Integration Services", and "Reporting Services" are ALL can be connected, ONLY "Analysis Services" CANNOT be connected in the "Microsoft SQL Server Management Studio".

|||(1) I removed and re-installed Microsoft SQL Server 2005 Developer Edition on my Windows XP Professional, yet the error remains.
(2) I, then, downloaded and installed Microsoft SQL Server 2005 SP1, and try again, the error remains.
(3) I also remove and reinstall my Network Interface Card on my IBM ThinkPad, and start all services who can be started on my Operating System, the error remains.
Who can help me, God?|||

Another idea.

This could be a network related. Instead of localhost try to use machine name or IP of your server.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks God! I fixed this problem, but I really do not know how and why?

I will do some experiment and try to find it out (this may take me several hours or days or never), but now, I only list what I did -

(1) There is an error "Could not add the requested component.
The error is: ...."(sorry for lost details) when I try to install Microsoft TCP/IP version 6 on my Network Adapter;

(2) There is an error "Unable to start the MSMQ service. Error Code: 0x433
Error description: The dependency service does not exist or has been marked for deletion. "
and/or "Setup could not copy one or more files. The specific error code is 0x4b8..."
and/or "The MSMQTriggers service cannot be started. Error Code: 0x42C Error Description: The dependency service or group failed to start."
When I removed and try to re-install Message Queuing;

(3.1) To resolve 0x4b8, I running this command:
esentutl /p c:\WINDOWS\security\Database\secedit.sdb

(3.2) To resolve 0x42C, I found a very useful message on Etc. Windows.
http://www.google.com/notebook/public/04097591150171922613/BDT6NIgoQlMDj180h
and running these commands:

net stop msdtc

msdtc -uninstall

go into regedit and delete the key HKLM\Software\Microsoft\MSDTC

msdtc -install

net start msdtc

(3.3) Now, I can continue to re-install Message Queuing.

(4) Check and install Microsoft TCP/IP version 6.

(5) Connect to localhost (Analysis Server) in Microsoft SQL Server Management Studio. It is OK now!

I really don't know how to fixed but I finally fiexed it anyhow! If you doubt whether it meets your case or not, please just take a trial; If you want to contact me, please email to huangxiangyao@.hotmail.com.

|||

Thanks God! I fixed this problem, but I really do not know how and why.

I will do some experiment and try to find it out (this may take me several hours or days or never), but now, I only list what I did -

(1) There is an error "Could not add the requested component.
The error is: ...."(sorry for lost details) when I try to install Microsoft TCP/IP version 6 on my Network Adapter;

(2) There is an error "Unable to start the MSMQ service. Error Code: 0x433
Error description: The dependency service does not exist or has been marked for deletion. "
and/or "Setup could not copy one or more files. The specific error code is 0x4b8..."
and/or "The MSMQTriggers service cannot be started. Error Code: 0x42C Error Description: The dependency service or group failed to start."
When I removed and try to re-install Message Queuing;

(3.1) To resolve 0x4b8, I running this command:
esentutl /p c:\WINDOWS\security\Database\secedit.sdb

(3.2) To resolve 0x42C, I found a very useful message on Etc. Windows.
http://www.google.com/notebook/public/04097591150171922613/BDT6NIgoQlMDj180h
and running these commands:

net stop msdtc

msdtc -uninstall

go into regedit and delete the key HKLM\Software\Microsoft\MSDTC

msdtc -install

net start msdtc

(3.3) Now, I can continue to re-install Message Queuing.

(4) Check and install Microsoft TCP/IP version 6.

(5) Connect to localhost (Analysis Server) in Microsoft SQL Server Management Studio. It is OK now!

I really don't know how to fixed but I finally fiexed it anyhow! If you doubt whether it meets your case or not, please just take a trial; If you want to contact me, please email to huangxiangyao@.hotmail.com. (From 1:00 to 17:00 UTC)

Again and Again SQLServer DB connection How?WHy

Hi All:
I really Shocked,These days I just really shocked what`s going happen behind
the WindowsSP2 and Windows Server 2003 (SP1)'
when I see that I can Connect to the MSSQL through Win2k and WinXP(SP1) But
I can`t connect through those.
We have a Software that install MSDE DB instance on the Windows
Server2003(WINXPSP2 too) and we can`t connect to that?even when attached my
DB to SqlEnterprise Manager,again I couldn`t connect through that?I really
swamp into details of Windows Firewall I`ve really done everything that MS
Say about opening port ,etc but nothing happen
Now the things that important for me is that What really happen to these 2
Goddamn Windows Security happened to them. IMHO, long overdue.
What ports have you opened?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Hossein Kiaie" <hosseinpro@.gmail.com> wrote in message
news:uBTjkVo$FHA.3308@.TK2MSFTNGP11.phx.gbl...
> Hi All:
> I really Shocked,These days I just really shocked what`s going happen
> behind the WindowsSP2 and Windows Server 2003 (SP1)'
> when I see that I can Connect to the MSSQL through Win2k and WinXP(SP1)
> But I can`t connect through those.
> We have a Software that install MSDE DB instance on the Windows
> Server2003(WINXPSP2 too) and we can`t connect to that?even when attached
> my DB to SqlEnterprise Manager,again I couldn`t connect through that?I
> really swamp into details of Windows Firewall I`ve really done everything
> that MS Say about opening port ,etc but nothing happen
> Now the things that important for me is that What really happen to these 2
> Goddamn Windows
>|||Thanks Man:
I opened TCP and UCP 1433
But nothing Happen
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uIX7ngo$FHA.2320@.TK2MSFTNGP11.phx.gbl...
> Security happened to them. IMHO, long overdue.
> What ports have you opened?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Hossein Kiaie" <hosseinpro@.gmail.com> wrote in message
> news:uBTjkVo$FHA.3308@.TK2MSFTNGP11.phx.gbl...
>|||I am Sorry But Let me Explain it clearly:
1.We Have Windows Server 2003 SP1 server
2.Install Our Software that install MSDE DB instance
3.We have Client that want to connect to this but they get"Sql doesn`t
exist/access denied"
4.the point is this problem never happen with Windows XP XP1 or Windows 2000
So What Should i do Now?
Please Help ME Thanks
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uIX7ngo$FHA.2320@.TK2MSFTNGP11.phx.gbl...
> Security happened to them. IMHO, long overdue.
> What ports have you opened?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Hossein Kiaie" <hosseinpro@.gmail.com> wrote in message
> news:uBTjkVo$FHA.3308@.TK2MSFTNGP11.phx.gbl...
>

Again and Again SQLServer DB connection How?WHy

Hi All:
I really Shocked,These days I just really shocked what`s going happen behind
the WindowsSP2 and Windows Server 2003 (SP1)?
when I see that I can Connect to the MSSQL through Win2k and WinXP(SP1) But
I can`t connect through those.
We have a Software that install MSDE DB instance on the Windows
Server2003(WINXPSP2 too) and we can`t connect to that?even when attached my
DB to SqlEnterprise Manager,again I couldn`t connect through that?I really
swamp into details of Windows Firewall I`ve really done everything that MS
Say about opening port ,etc but nothing happen
Now the things that important for me is that What really happen to these 2
Goddamn Windows
Security happened to them. IMHO, long overdue.
What ports have you opened?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Hossein Kiaie" <hosseinpro@.gmail.com> wrote in message
news:uBTjkVo$FHA.3308@.TK2MSFTNGP11.phx.gbl...
> Hi All:
> I really Shocked,These days I just really shocked what`s going happen
> behind the WindowsSP2 and Windows Server 2003 (SP1)?
> when I see that I can Connect to the MSSQL through Win2k and WinXP(SP1)
> But I can`t connect through those.
> We have a Software that install MSDE DB instance on the Windows
> Server2003(WINXPSP2 too) and we can`t connect to that?even when attached
> my DB to SqlEnterprise Manager,again I couldn`t connect through that?I
> really swamp into details of Windows Firewall I`ve really done everything
> that MS Say about opening port ,etc but nothing happen
> Now the things that important for me is that What really happen to these 2
> Goddamn Windows
>
|||Thanks Man:
I opened TCP and UCP 1433
But nothing Happen
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uIX7ngo$FHA.2320@.TK2MSFTNGP11.phx.gbl...
> Security happened to them. IMHO, long overdue.
> What ports have you opened?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Hossein Kiaie" <hosseinpro@.gmail.com> wrote in message
> news:uBTjkVo$FHA.3308@.TK2MSFTNGP11.phx.gbl...
>
|||I am Sorry But Let me Explain it clearly:
1.We Have Windows Server 2003 SP1 server
2.Install Our Software that install MSDE DB instance
3.We have Client that want to connect to this but they get"Sql doesn`t
exist/access denied"
4.the point is this problem never happen with windows XP XP1 or Windows 2000
So What Should i do Now?
Please Help ME Thanks
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uIX7ngo$FHA.2320@.TK2MSFTNGP11.phx.gbl...
> Security happened to them. IMHO, long overdue.
> What ports have you opened?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Hossein Kiaie" <hosseinpro@.gmail.com> wrote in message
> news:uBTjkVo$FHA.3308@.TK2MSFTNGP11.phx.gbl...
>

After 2 ODBC Connections, connection failes forever

Hi,
I had a C# .NET application that connected to SQL Server with ADO.NET.
All went well.
Then, I had to change the connection to an ODBC connection (to be able
to later connect to another type of db, too).
When I start my app, the app connects twices through ODBC with the SQL
Server -
without problems, twice open and close.
>From the 3rd time onwards, the connection fails with the exception:
"ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Serve
r]Login
failed for user 'OmegaStats'."
This doesn't make any sense. The authenthication went okay twice, but
from the 3rd time onwards, it doesn't work anymore....?!!
Does anyone have any clue what this could be?
Thanks,
JoanI'd follow the clue given in the error message, and use a tool like osql.exe
or Query Analyzer to connect to the SQL instance with that user and its
password to verify if the password was somehow changed.
Linchi
"Joan" wrote:

> Hi,
> I had a C# .NET application that connected to SQL Server with ADO.NET.
> All went well.
> Then, I had to change the connection to an ODBC connection (to be able
> to later connect to another type of db, too).
> When I start my app, the app connects twices through ODBC with the SQL
> Server -
> without problems, twice open and close.
> "ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Ser
ver]Login
> failed for user 'OmegaStats'."
> This doesn't make any sense. The authenthication went okay twice, but
> from the 3rd time onwards, it doesn't work anymore....?!!
> Does anyone have any clue what this could be?
> Thanks,
> Joan
>|||Indeed, after startup an odbc connection string is created including
the password. Upon the 3rd connection, the password has mysteriously
disappeared from the connection string. Why?
Thanks,
Joan