Connecting with (Local) via asp.net To sql server 2000

Connecting with (Local) via asp.net To sql server 2000

Post by Reza Saheba » Fri, 13 Dec 2002 09:22:41



Hello
For ASP.NET:
My Windows Is XP pro.in my computer class when I used
(local), Database connection worked but at home I had to
give my server name to make it work.See line 2,instead of
(local) I gave my server name and SQL Server worked
correctly,in class (local) worked as well,but class's
Windows was server 2000,is it because of that windows?It
means sql Server 2000 in Windows XP doesn't know (local)?

ConnStr = "Provider=SQLOLEDB; Data Source=UNIVERSI-
....NQ\NetSDK; Initial Catalog=ASPNET;User ID=sa;"

you see instead of (Local) I gave UNIVERSI-....NQ\NetSDK
which is my server name and it works.
Do you think it is because that sql Server 2000 in
Windows XP doesn't know (local)?
A friend told me:
"You can change where (local) maps to (ie to
YourComputerName\NetSDK) by using the system sproc:
sp_addserver "
But I don't know how to do that,Could give me a step by
step instruction?

Regards
Reza Saheban

 
 
 

1. Can't connect to SQL 2000 via ASP.Net

I just installed an evaluation version of SQL Server 2000 on my machine, so
to run some tests with ASP.Net. I assumed that by using only NT
authentication (not mixed), I could simply use the same username/password I
use to log on as an administrator. I am probably doing something wrong, as I
keep getting this error:

Login failed for user 'damiano'. Reason: Not associated with a trusted SQL
Server connection.

How do I associate this user to a trusted SQL Server connection?

Damiano

2. Delphi ODBC access to AS/400 database

3. Problem Connecting to SQL Server 2000 Database from deployed ASP.NET app

4. Can I use delphi 2.0 compile a program to 16bits version for Windows 3.1

5. how to connect remote sql server 2000 from my local sql server 2000

6. Procedure parameters.

7. cant connect to sql server 2000 over network in asp.net

8. Sys1orcl.ora corrupt

9. Setting up Local SQL server and use VS.net to debug ASP.net

10. Newbie needs code pages for SQL Server 2000 access from asp.net page using vb.net

11. System DSN: LocalServer - after installation SQL Server 2000 - can not connect to the (local) server

12. Connecting to Sql Server from asp after upgrade from ms sql 7 to ms sql 2000