hi all,
i am using asp.net,
i was trying to connect to a new sqlserver but a return error msg returned "sql server does not exist or access denied", i transfer the program to the remote sqlserver server and it works fine, also i use the same connection string to connect to the remote sqlserver from my machine using vb.net(desktop application) and it works fine, so the problem here with asp.net, any help !!!
do any face this problem.:(




Ahmed Ali
Software Developer

__________________
Ahmed Ali
Senior Software Developer

Fast judge! It might be from ur Network Connection.
did u tried from another PC or not?! Does ur PC connected to LAN or not?!
Kepp in touch.

Always:),
Hovik Melkomian.

my pc is on a lan with the server,
i can connect to the server using client QA from pc also i can connect using a test Desktop application(vb.net) the problem when connecting using asp.net

Ahmed Ali
Software Developer

How are you trying to connect to the server with ASP.NET?

i am using ado.net,

for ex.
dim conStr as string="data source=XXXXX;Initial Catalog=XXXXX;User id=XXXXX;Pwd=XXXXX;"
dim conn as new sqlconnection(connStr)
dim cmd as new sqlcommand(QueryStr,conn)
conn.open
cmd.executescalar
conn.close

note : i use the same code as check in Desktop App with the same connection string and it works fine



Ahmed Ali
Software Developer