Solved

DSN in Windows XP with MS SQL server

Posted on 2004-05-03
12
501 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
  • 6
  • 6
12 Comments
 
LVL 19

Accepted Solution

by:
Melih SARICA earned 300 total points
Comment Utility
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
Comment Utility
sorry but
can MSSQL server 2000 run on window xp
0
 

Author Comment

by:chetanpatel
Comment Utility
sorry but
can MSSQL server 2000 developer  run on window xp professional
0
 
LVL 19

Expert Comment

by:Melih SARICA
Comment Utility
yep it can run
0
 

Author Comment

by:chetanpatel
Comment Utility
can u write procedure to installed?
0
 
LVL 19

Expert Comment

by:Melih SARICA
Comment Utility
Procedure of what ?
be more specific...
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:chetanpatel
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility

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
Comment Utility
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
Comment Utility
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now