Problem in Accessing SQL Server from .net

[mohi76bd]

Hi..

I have a sql server instance named Pedrollo-yxczvi\warranty with sql server instances. I hv written following connection string for connecting with the database:

_connectionString = "Server=PEDROLLO-YXCZVI\WARRANTY;Database=MarketAnalysis;User ID=usr;Password=pass;"

but the program giving error "Server doesn't exist or access denied" though I am accessing the same instance from my other program written in ASP.net/VB 6.0.
but when i am changing to another instance of sql server running on other computer ; this equivalant code is working.

I am just wonder is there any problem about naming of this instance or limitation of .net developer regarding this.

Can anybody help me?

Asif

[shweta123]

Hi,

Try using this connectionString

"Provider=SQLOLEDB.1;Persist Security Info=True;User ID=usr; password=pass;Initial Catalog=MarketAnalysis ;Data Source=PEDROLLO-YXCZVI\WARRANTY"

[rsiena]

Try this

connectionString="Server=YourServer;Database=YourD atabase;uid=sa;pwd=1234;" providerName="System.Data.SqlClient"

Make sure that what ever name you give your server that you can ping it from a command promt with that name or it might not be able to find it on the network

For example you might need yourserver.domain.com instead of the just the machine name