SP2 & Sql server connection problem?

[Lloyd Dupont]

I have a weird, weird problem.
I'm no longer able to access my SqlServer on my Desktop from my PocketPC!

I use simple connection string like:
"Database=northwind;Data Source=172.16.0.115;User ID=user;Pwd=pwd"

it doesn't connect anymore! (it used to connect without problem)
I just install SP2, could it be the reason?



Also in the news....

I just realize it might be possible to use integrated windows security, even
on my PocketPC.
I mean it might be possible to have a connection string wich contain not a
database User/Password, but a windows domain user/pwd and used this to knid
of connect with SSPI security.

However the desciption of SqlConnection.ConnectionString specify the
contrary and http://www.connectionstrings.com/ doesn't show me any way way
to achieve that.

Any tips?

 

[Darryn Ross]

SP2 has some serious issues with alot of applications including Office XP..
you need to check out the release notes for the Service pack on the
Microsoft website to see if there is a issue SqlServer.

 

[William \(Bill\) Vaughn]

I have SP2 installed on all of my test systems. I have seen the port issue
and once corrected, I have not seen other issues.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________