Re: Cant Login on a sql2005 machine from VS2005 IDE debug mode
- From: "Norman Yuan" <FakeName@xxxxxxxxxxxxx>
- Date: Fri, 25 Jan 2008 07:27:42 -0700
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" <ChiWhiteSox@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:BCC6DF54-6D0C-40B3-8704-67707836D7C5@xxxxxxxxxxxxxxxx
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?
.
- Prev by Date: Sorting lists in .Net - why it sucks
- Next by Date: Re: Sorting lists in .Net - why it sucks
- Previous by thread: Sorting lists in .Net - why it sucks
- Next by thread: Bring To Front
- Index(es):
Relevant Pages
|
|
