SQL Server Data Access
Thanks,
Rob
Do you have a domain controller and home network
If not, then you must create use SQL logins -you cannot use Windows authentication without an Active Directory (domain controller).
I don't even know what those things mean.
How would I go about doing this with SQL logins
Rob
I suggest you follow the steps under "To configure AdventureWorks to work with Web server controls" on the following page from the Books Online.
http://msdn2.microsoft.com/en-us/library/ms310325(vs.80).aspx
Hopefully this helps,
John
So I read over the link provided...
I have completed the first part and added it to the server. I can access the database on my desktop machine, when I login from the laptop however (using the same windows login) I can't access to database...do I need to also add something to make it accessible remotely I don't really understand what "configure AdventureWorks to work with Web server controls
" means..
Rob
These resources might help.
Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx scid=kb;EN-US;914277
Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
I have done this...as I stated before I can connect fine its just that I can't see anything other than system db's...I imagine I'm missing something stupid, like perhaps I didn't configure the login correctly
Rob
The login needs to be provided permission to access the databases.
Add the login to the appropriate database role.
Ok first...I am running XP home on both the desktop and laptop...and the logins are windows auth.
if I want full access from the remote connection, where do I change the role of the login is it in the login menu or the databases menu
Rob
Look back at the first response given to your problem.
Windows authentication will not work in your situation -you do not have a domain controller.
You will need to establish SQL Logins in each server, and assign permissions accordingly.
Look in Books Online about creating SQL Logins.