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-08 : 13:32:13
|
| I bought the book Microsoft SQL server 2005 integration services and transferred the sample data from the CD (came with the book) to my system as per their instructions. When I started practicing; I faced the problem of failed login. They told to open the ‘sample solutions’. So I opened it and it automatically opened in the BIDS. Then I double clicked the ‘scrapreason.dsv’. In the book they stated that in the DSV, " right click the named query, scrapped products (it is a table in the view), 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 windows authentication to server and windows authentication mode. But yet I could not solve it. But I have been working with my Adventureworks and AdventureworksDW without any problem. I face this problem only when I access the data ‘is2005sbs’ came with the CD. I also find this db in the SSMS and I could open all the tables in the particular db. Why the BIDS could not connect to db ‘is2005sbs’.When I loaded the data from the CD, they said that <username> is the logon name I use to operate my computer.My logon name I use it to use my system ‘senthilvelan’ and my computer name is 'senthilv-be2a81’. When I open the SSMS, in the dialog box to connect; I see the user name is 'senthilv-be2a81/senthilvelan'. some guys suggested in the forum 1. create a login account in the system 'senthilv-be2a81/senthilvelan'. But I tried. The system wont accept more words as login name as well as \ in the login name. 2. another option is: configure the sql - server for remote serve acceptance, in the server configuration - and then create a login name senthilvelan in the SMS studio - security - log in options. And then open the SSMS during connect - opting for server authentication. It also did not work. Can any one help me to solve the issue.Thanks in advance |
|
|
asenthilvelan
Starting Member
25 Posts |
Posted - 2008-09-09 : 10:26:23
|
| I solved the issue with a help of Mangal Pardeshi from MSDN forum.Thanks a lot for all those attention |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-09 : 10:31:45
|
Good for you!Do you like to share your knowledge so that other people can learn from your situation?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
asenthilvelan
Starting Member
25 Posts |
Posted - 2008-09-09 : 21:43:17
|
| Credit to Mr. Mangal.Here are my steps. * I loaded the data in the C:\Documents and Settings\Senthilvelan\My Documents\Microsoft Press\IS2005SBS.* Now , In the BIDS, I opened the ‘db source’ to ascertain that connection string is correct and is pointing towards my target db ‘is2005sbs’.* Double clicked the db ‘is2005sbs’ – data source designer dialog box appeared.* Connection string was “ provider=sqlnccI.1; data source= local host; integrated security=ssp; initial catalogue=is2005sbs”.* Found the data source as ‘local host’.* I went to edit and got connection manager. * Now the provider is Native Oledb\ SQL NATIVE CLIENT (of course it was there already).* Now changed the server from local host to my computer name - 'senthilv-be2a81’ then – windows authentication. * Database already showed my db ‘is2005sbs’* Now I checked the test connection – now also failed.* Now I selected the db ‘is2005sbsDW’ from the drop down menu .* Now, test connection was successful.* Now everything is OK |
|
|
|
|
|
|
Solve my puzzle