Cant Login on a sql2005 machine from VS2005 IDE debug mode

[ChiWhiteSox]

Hi,

i got machine A that has sql2005, vs2005 project. project runs okay there.
But when i copied that whole project folder to machine B, running sql2005,
VS2005, edited the web.config file to point to SQL2k5 machine A, and then run
it at VS2005, it cant connect to the DB at machine A. It says, unable to
connect to DB, server doesnt allow remote connections. But when i try to
connect to machine A using SQL SMS, im able to browse to the tables. I also
did the SQL allow remote connection using TCP/IP and browseable at the SQL
configuration at machine A. Also added the sqlbrowser.exe and sqlserver.exe
at the firewall exceptions. Thing is, it cant login to the tables using the
asp_net Login controls.

any ideas?

 

[Norman Yuan]

Assume the SQL Server in box A is set up correctly (can be accessed from
network. It seems it is the case according to your description, since you
used SSMS in box B being connected to the SQL Server).

What type is the application? ASP.NET or Win Form? What is the
ConnectionString used by the app? What does it mean "login to the tables"?
SQL Server user logs in to Sql Server, and then they access SQL Server
objects (tables, views....) od given database according to the permissions
they are given. They do not log in to tables.

So, you need to

1. examine your connectionString to make sure your app can connect to the
given database;
2. examine the permissions assigned to the SQL Server login/database user to
see if the user has appropriate permission to the data (SELECT... UPDATE...
DELETE....EXECUTE...) with SQL Server objects (table, view,sp...)