SQL Server Performance Forum – Threads Archive
Newbie: Need to login to SQL Server
I’d like to get data from SQL Server using the "Get External Data" function within XL. My only problem is "what’s the username & password I use to log in?". If I have to create a user on the SQL Server, how do I do it? |+– Julian
|
it is the SQL user of your sql server database. hoe do you connect to the SQL Server. Use that username and password —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka
Referhttp://www.informit.com/guides/content.asp?g=sqlserver&seqNum=135&rl=1 also. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Hi,<br /><br />i guess you are using Windows Authentication on your Sql Server, ok, see these steps below:<br />EXCEL:<br />DATA – GET External DATA – New Database Query<br />New Data Source – OK<br />Give a DS name<br />Connect – Enter the Server Name and Choose "Use Trusted Connection" if you are using Windows Authentication or enter a user name and password, if you are using default SQL Server configutation, it is normally Windows Auth<br />Choose OK<br />And that’s it.[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br /><br /><br /><br />AKTHAR DILMOHAMUD<br />65 BENARES ST<br />PORT LOUIS<br />MAURITIUS
hi julian,<br /><br />was the information of any help[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br /><br />AKTHAR DILMOHAMUD<br />65 BENARES ST<br />PORT LOUIS<br />MAURITIUS
]]>