ms sql connection string mi pojede zivceImam racunar, u njemu virtuelnu masinu, u virtuelnoj masini imam podignut web service koji ima sledeci connection string:
Code:
Data Source=xxx.xxx.xxx.xxx\SQLExpress;Initial Catalog=db;Trusted_Connection=yes;
Data Source=xxx.xxx.xxx.xxx\SQLExpress;Initial Catalog=db;Trusted_Connection=yes;
I ovo radi kada pokrenem unutar virtuelne masine.
Onda sam pozvao ovaj web service iz host masine koja sve lepo procita i onda pozovem ws metod koji treba da odradi nesto sa bazom i ono mi vrati prazan rezultat, sto znaci da nije usao u bazu, ne znam sta da mu radim???
PS
Ukljucen mi je mixed mode tcp/ip, named pipes...
Pardon:
Cak ni u lokalu mi ne radi kada stavim IP adredu \ SQLExpress. Radi samo kada stavim .\Sql.... Dobijam sledecu gresku:
Code:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
[Ovu poruku je menjao Valerij Zajcev dana 07.03.2011. u 12:43 GMT+1]
U stvari cim pozovem servis sa IIS-a ono nece da radi :(
[Ovu poruku je menjao Valerij Zajcev dana 07.03.2011. u 13:06 GMT+1]
