Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asenthilvelan
Starting Member
25 Posts |
 Posted - 2008-09-05 : 10:46:09
|
| Hi all,I am new to SQL. I am learning SQL 2000 and 2005 by online course. I bought the book Microsoft SQL integration services 2005 and transferred the sample data. When I started working acc. to book, it does not allow me by stating that login failed " user" to databse.bla bla..Can any one help me ?Senthil |
|
|
ma.voice
Starting Member
12 Posts |
Posted - 2008-09-06 : 13:22:47
|
| Send the exact error description please.Cheers.Silent VoiceBill Gates, MVP |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-06 : 14:00:47
|
| When you installed MS SQL did you choose windows authentication or mixed mode ? |
|
|
|
asenthilvelan
Starting Member
25 Posts |
Posted - 2008-09-06 : 15:14:02
|
| Hi friends,Thanks for your attention. I bought the book Microsoft SQL server 2005 integration services and transfered the sample data from the CD (came with the book) to my system as per their instructions. Whenever I access the data 'is2005Sbs', it states that login failed for the 'user' to the database is2005Sbs in BIDS. In the book they state " right click the named query, scrapped products, and choose Edit named query to view the transact -SQL query joining five tables in the Transact-SQL Graphical Query Designer". when I do this It says " login failed for user 'senthilv-be2a81/senthilvelan'. can not open database 'is2005sbs' requested by the login. The login failed". Then in the microsoft support web site I found similar Question - the answer is change server properties from windows authentication mode to mixed mode. I went to server management studio and right click the server in the object explorer slot and went to properties - then to security and changed the server windows authentication to server and windwos authentication mode. But yet I could not solve it. If such a problem persist, how I can I practice the whole book ?. But I have been working with my Adventureworks and AdventureworksDW without any problem.**********Dear my friend afrika - while installing the sql server I chosen windows authentication mode. However I got a clue from microsoft support website then I changed to mixed mode. But no use till now.Thanks for your help in advance. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-06 : 15:46:01
|
| Now that you have changed it to mixed mode. What username and password did you set ? |
|
|
|
asenthilvelan
Starting Member
25 Posts |
Posted - 2008-09-06 : 17:19:58
|
| I know that I used my computername ie 'senthilve-be2a81' as username while installing the sql but I did not give password anywhere.Before buying this book, I work with adventureworks and adventureworksDW and till now I am working with those databases without any problem. Evennow I can open the tables of db 'is2005sbs' in the management studio. |
|
|
|
|
|
|
Login failed