chetanpatel
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sorry but
can MSSQL server 2000 developer run on window xp professional
can MSSQL server 2000 developer run on window xp professional
yep it can run
ASKER
can u write procedure to installed?
Procedure of what ?
be more specific...
be more specific...
ASKER
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..
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..
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
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
ASKER
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
/asp/testing.asp, line 3
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
/asp/testing.asp, line 3
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
go
EXEC sp_grantdbaccess 'HOME-YYOROCZYSJ\IUSR_HOME
ASKER
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.
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.
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
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
ASKER
can MSSQL server 2000 run on window xp