DSN in Windows XP with MS SQL server

Hi there
I installed MS SQL server 2000 developer edition in windows xp professional. How to make DSN in window xp to connect MS SQL server? server is running HOME - YYOOSOR..
Please help

Thanks in advance
chetanpatelAsked:
Who is Participating?
 
Melih SARICAConnect With a Mentor IT ManagerCommented:
Control panel -> Administrative tools->ODBC data sorurces...

New.. Select SQL server from the provider list..

type 127.0.0.1

user name and password..

test it..

Melih SARICA
0
 
chetanpatelAuthor Commented:
sorry but
can MSSQL server 2000 run on window xp
0
 
chetanpatelAuthor Commented:
sorry but
can MSSQL server 2000 developer  run on window xp professional
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
Melih SARICAIT ManagerCommented:
yep it can run
0
 
chetanpatelAuthor Commented:
can u write procedure to installed?
0
 
Melih SARICAIT ManagerCommented:
Procedure of what ?
be more specific...
0
 
chetanpatelAuthor Commented:
I installed MSsql and it run.  
i made  database and table but i cannot access this database through dsn so what should i do? also i cannot make login in security..
0
 
Melih SARICAIT ManagerCommented:
ok

lets start it..

first lets try to connect from osql
  from command prompt
   c:\>osql -E

it means connect my server .. and use trusted connection..
if it connects..  we ll go on working other steps
0
 
chetanpatelAuthor Commented:
I got this error

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'HOME-YYOROCZYSJ\IUSR_HOME-YYOROCZYSJ'.
/asp/testing.asp, line 3
0
 
Melih SARICAIT ManagerCommented:

when u type it from command prompt ?

r u sure  ? becouse..

IUSR_HOME-YYOROCZYSJ is the internet user.. used for anonymous internet access user...

ok

i guess ur trying to connect from internet explorer

run SQL analyzer  execute this sql

exec sp_addlogin 'HOME-YYOROCZYSJ\IUSR_HOME-YYOROCZYSJ'
go
EXEC sp_grantdbaccess 'HOME-YYOROCZYSJ\IUSR_HOME-YYOROCZYSJ' , Urdatabasename

0
 
chetanpatelAuthor Commented:
HI non zero

thanks it working.
now what i want to import file from ISP, i have ipaddress, servername, login, password

so how can i connect with ISP server through my local server.

thanks again.
0
 
Melih SARICAIT ManagerCommented:
Connect ur ISP admin.

They ll give u an IP address, Username and password to make a connection between Web pages and DataBase..

Change the specific Fields in ur Connection String and its ok ...


Hope it helps..

Melih SARICA
thx 4 points
0
All Courses

From novice to tech pro — start learning today.