Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Changing Authentication mode of connecting to Integration Services Expand / Collapse
Author
Message
Posted Sunday, October 25, 2009 1:24 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 29, 2014 5:46 PM
Points: 182, Visits: 737
In Managment studio(SQL SERVER 2008),I am trying to connect to Integration Services.But it is always in windows Authetication and I can not chnage it to SQL authentication .My login is sysadmin, but when I am trying to connect in window Authentication it says access denied.
1-How is it possible to change the authentication mode to SQL Authentication of cnnecting to SQL SERVER 2008 Intgration Services?
2-why my login (sysadmin) can not access to Integration Services and How can I give this permission to my user?

Thanks
Post #808391
Posted Monday, October 26, 2009 7:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 24, 2010 1:20 AM
Points: 9, Visits: 66
me too!
Post #808651
Posted Monday, October 26, 2009 8:32 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 1:30 PM
Points: 3,428, Visits: 14,432
Aspet Golestanian Namagerdi (10/25/2009)
In Managment studio(SQL SERVER 2008),I am trying to connect to Integration Services.But it is always in windows Authetication and I can not chnage it to SQL authentication .My login is sysadmin, but when I am trying to connect in window Authentication it says access denied.
1-How is it possible to change the authentication mode to SQL Authentication of cnnecting to SQL SERVER 2008 Intgration Services?
2-why my login (sysadmin) can not access to Integration Services and How can I give this permission to my user?

Thanks


If your SQL Server is Windows authentication you cannot change authentication at the point of connection, you must configure mixed authentication before trying to connect. In SQL Server at the top right click and go to server properties under security change to both SQL Server and Windows authentication and you can use SQL authentication to connect to SSIS.


Kind regards,
Gift Peddie
Post #808736
Posted Monday, October 26, 2009 9:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 29, 2014 5:46 PM
Points: 182, Visits: 737
Thx for reply,But the SQL Server is on "SQL SERVER and Windows Authentication mode",but still I can chnage it during connecting to Integration Services.
Post #808772
Posted Monday, October 26, 2009 9:59 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 1:30 PM
Points: 3,428, Visits: 14,432
Aspet Golestanian Namagerdi (10/26/2009)
Thx for reply,But the SQL Server is on "SQL SERVER and Windows Authentication mode",but still I can chnage it during connecting to Integration Services.


If SQL Server is in both Windows and SQL Server mode you should be able to use SQL Server authentication if you cannot use it then the system admin account is disabled when you installed SQL Server with Windows authentication so you need to enable it. Check the links below for details and how to enable it.

http://msdn.microsoft.com/en-us/library/ms188670.aspx

http://blog.sqlauthority.com/2008/12/24/sql-server-disable-and-enable-user-sa/



Kind regards,
Gift Peddie
Post #808812
Posted Monday, October 26, 2009 1:31 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 29, 2014 5:46 PM
Points: 182, Visits: 737
Thanks alot for th replys.
I guess I found the answer.Please refer to the link
http://technet.microsoft.com/en-us/library/ms180068.aspx
but How can I give this permission(Connecting to intigration Services) to a user
Post #808937
Posted Monday, October 26, 2009 1:52 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 1:30 PM
Points: 3,428, Visits: 14,432
Aspet Golestanian Namagerdi (10/26/2009)
Thanks alot for th replys.
I guess I found the answer.Please refer to the link
http://technet.microsoft.com/en-us/library/ms180068.aspx
but How can I give this permission(Connecting to intigration Services) to a user


That is related to connection within SQL Server Management Studio but if you are connecting in BIDs the development tool you can change authentication mode as needed.

Which is default depends if your data source is SQL Server or other RDBMS.



Kind regards,
Gift Peddie
Post #808952
Posted Monday, October 26, 2009 2:03 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 29, 2014 5:46 PM
Points: 182, Visits: 737
I know,My question is related to Managment studio environment.Now,how can I give the right of access to "Integration Service" to an windows account.Actually this will solve my problem.

Thanks
Post #808960
Posted Monday, October 26, 2009 2:13 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 1:30 PM
Points: 3,428, Visits: 14,432
Aspet Golestanian Namagerdi (10/26/2009)
I know,My question is related to Managment studio environment.Now,how can I give the right of access to "Integration Service" to an windows account.Actually this will solve my problem.

Thanks


It will only solve the problem if mixed mode is not used to develop packages in BIDs you have to remember that because these issues can take a long time to resolve if the connection to the base problem is not addressed.



Kind regards,
Gift Peddie
Post #808967
Posted Monday, October 26, 2009 3:35 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 29, 2014 5:46 PM
Points: 182, Visits: 737
Thx,But How can I give the right of access to "Integration Service" to an windows account
Post #809008
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse