Solved

DSN in Windows XP with MS SQL server

Posted on 2004-05-03
12
507 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
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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Live Storage Vmotion VMs with shared VMDK 10 61
Linked Server Issue with SQL2012 3 26
create an aggregate function 9 36
Show Results for Latest DateTime in a View 27 25
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

821 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