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...)
"ChiWhiteSox" <(E-Mail Removed)> wrote in message
news:BCC6DF54-6D0C-40B3-8704-(E-Mail Removed)...
> 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?
>
|
Similar Threads
