Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

DSN in Windows XP with MS SQL server

Posted on 2004-05-03
12
Medium Priority
?
515 Views
Last Modified: 2012-05-04
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
0
Comment
Question by:chetanpatel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 6
12 Comments
 
LVL 19

Accepted Solution

by:
Melih SARICA earned 900 total points
ID: 10978127
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
 

Author Comment

by:chetanpatel
ID: 10986761
sorry but
can MSSQL server 2000 run on window xp
0
 

Author Comment

by:chetanpatel
ID: 10986766
sorry but
can MSSQL server 2000 developer  run on window xp professional
0
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
LVL 19

Expert Comment

by:Melih SARICA
ID: 10986818
yep it can run
0
 

Author Comment

by:chetanpatel
ID: 10986933
can u write procedure to installed?
0
 
LVL 19

Expert Comment

by:Melih SARICA
ID: 10986972
Procedure of what ?
be more specific...
0
 

Author Comment

by:chetanpatel
ID: 10987048
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
 
LVL 19

Expert Comment

by:Melih SARICA
ID: 10987103
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
 

Author Comment

by:chetanpatel
ID: 10987171
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
 
LVL 19

Expert Comment

by:Melih SARICA
ID: 10987275

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
 

Author Comment

by:chetanpatel
ID: 10988587
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
 
LVL 19

Expert Comment

by:Melih SARICA
ID: 10993046
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

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how the fundamental information of how to create a table.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question