Click here to Skip to main content
11,921,835 members (65,811 online)
Rate this:
Please Sign up or sign in to vote.
See more: VB VB.NET
I loaded Sql Server 2008 on a Windows Server 2003 machine and my client machine is Windows 7 .

When i connect from windows 7 using SQL MANAGEMENT STUDIO it is connection. but when i connect through my application is it showing sql server error 40.

my connection string is
Data Source=192.168.1.XXX,1433; Network Library=DBMSSOCN; Initial Catalog=myDB;
User ID=myUserName; Password=myPwd
but when i connect through windows xp machine it is working fine.

it it the problem of connection string? Please help

Thanks in advance
Posted 6-Feb-13 19:13pm
Edited 11-Feb-13 12:30pm
Maciej Los209.9K
Maciej Los 11-Feb-13 17:31pm
SQL Server 2008 is installed on Windows Server 2003 32 or 64 bit?
Windows 7 is 32 or 64bit OS?

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 538
1 Dave Kreskowiak 260
2 Sergey Alexandrovich Kryukov 173
3 phil.o 170
4 RyanDev 134
0 OriginalGriff 7,036
1 KrunalRohit 4,530
2 Sergey Alexandrovich Kryukov 3,286
3 George Jonsson 2,840
4 Suvendu Shekhar Giri 2,216

Advertise | Privacy | Mobile
Web03 | 2.8.151120.1 | Last Updated 11 Feb 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100