Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Change SQL Server Authentication Programmatically


Hi,

Does anyone here know whether it is possible to change the
authentication method of a SQL server instance programmatically, rather
than going through enterprise manager.

I am using SQL-DMO (under C#) for some other things, but the
documentation is so bad that I can't find out whether what I want to do
can be done. I have also tried googling but came up empty handed.

I hope that someone can help me.

Cheers
Jono


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Server Authentication Change Question
Hello-
I recently inherited a SQL 2005 Standard database that I am being asked to change the Server authentication mode for. SQL system is managing a local database for Microsoft Systems Management Server 2003. Currently the system is running in SQL Server & Windows authentication mode. I am going to change it to Windows Authentication mode. Can someone point me to a checklist I could refer to before I make the change to be sure I don't take down my database?

Thanks in advance.
Erik

View Replies !   View Related
How To Change Authentication Mode In SQL Server
CREATE PROCEDURE dbo.uspSetSQLServerAuthenticationMode
(
@MixedMode BIT
)
AS

SET NOCOUNT ON

DECLARE @InstanceName NVARCHAR(1000),
@Key NVARCHAR(4000),
@NewLoginMode INT,
@OldLoginMode INT

EXEC master..xp_regreadN'HKEY_LOCAL_MACHINE',
N'SoftwareMicrosoftMicrosoft SQL ServerInstance NamesSQL',
N'MSSQLSERVER',
@InstanceName OUTPUT

IF @@ERROR <> 0 OR @InstanceName IS NULL
BEGIN
RAISERROR('Could not read SQL Server instance name.', 18, 1)
RETURN -100
END

SET@Key = N'SoftwareMicrosoftMicrosoft SQL Server' + @InstanceName + N'MSSQLServer'

EXEC master..xp_regreadN'HKEY_LOCAL_MACHINE',
@Key,
N'LoginMode',
@OldLoginMode OUTPUT

IF @@ERROR <> 0
BEGIN
RAISERROR('Could not read login mode for SQL Server instance %s.', 18, 1, @InstanceName)
RETURN -110
END

IF @MixedMode IS NULL
BEGIN
RAISERROR('No change to authentication mode was made. Login mode is %d.', 10, 1, @OldLoginMode)
RETURN -120
END

IF @MixedMode = 1
SET@NewLoginMode = 2
ELSE
SET@NewLoginMode = 1

EXEC master..xp_regwriteN'HKEY_LOCAL_MACHINE',
@Key,
N'LoginMode',
'REG_DWORD',
@NewLoginMode

IF @@ERROR <> 0
BEGIN
RAISERROR('Could not write login mode %d for SQL Server instance %s. Login mode is %d', 18, 1, @NewLoginMode, @InstanceName, @OldLoginMode)
RETURN -130
END

RAISERROR('Login mode is now %d for SQL Server instance %s. Login mode was %d before.', 10, 1, @NewLoginMode, @InstanceName, @OldLoginMode)
RETURN 0

E 12°55'05.25"
N 56°04'39.16"

View Replies !   View Related
Change The Authentication Mode Of The SQL Server
I installed SQL Server 2005 using Windows Authentication Mode (Windows Authentication)"

How can I change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
to "Mixed Mode (Windows Authentication and SQL Server Authentication)"?

View Replies !   View Related
SQL Server Express Authentication Mode Change
Does anyone know how to change the SQL Express authentication mode from Windows Authentication to Mixed Mode after it's already been installed?   

View Replies !   View Related
ASP Authentication With SQL Server 2005 - Not Express, Permanent Change
Hi all,
I've read up on the fact that if you use SQL server 2005 instead of SQL express you need to change the connection string in web.config.
Is there anyway to make this default connection type, or do I have to do it for every website I create. i.e. is there a global file that this connection can be entered into. Then whenever I start a new website I don't have to put the string in.
Just me being lazy really. But it's nice to know if it's possible.
 
Many thanks
DrB2k2

View Replies !   View Related
Cannot Change Server Authentication In Management Studio Express
I use the Mangement Studio Express to manage a MSDE 2000 instance and notice that the Server authentication area in the Security is disabled for that instance. But for an Express instance, the Server authentication area is enabled. Is this difference caused by some settings?


Thanks,

Peter

View Replies !   View Related
Export Report To PDF Programmatically (forms Authentication)
I use ReportExecutionService class to export a SQL reporting services report to a PDF file. It seems not work, and failed at method LoadReport?. The error message said: Object moved to <ReportServer Login Page>.

I think, its an authentication problem. The report server is set to form authentication, and I wrote a custom security DLL, and share the auth cookie with ASP.NET Web application. It works fine with ReportViewer.

I set ReportExecutionService.Credentials = System.Net.CredentialCache.DefaultCredentials. It looks like my network login windows account (MyDomainNameMyUserName), and of course it is failed. I read the ReportExecutionService class members, and can not find way to pass auth cookie, or some kind of forms authentication object into ReportExecutionService class.

Does anyone render report into PDF (HTML) file successfully by ASP.NET code for forms authentication?

I search the sample code over internet. The sample code only uses CredentialCache.DefaultCredentials, and it looks a windows authentication credential. Am I wrong?

Thanks for any suggestion and advice.Shaw

View Replies !   View Related
Change SQL Collation Programmatically
hi all... how can i change the collation of a table that i dynamically created during runtime??i wanna change the default collation to Arabic

View Replies !   View Related
Programmatically Change Property
In the old DTS, we can use the ActiveX Script to change any task's property programmatically.

Can we still do it in SSIS? Using the Script task? It seemschanging the value of variables then use aexpression can do some of the work, but what if a task has no expression defined?

Say, I want tochange the Fuzzy look up reference table name.

Can we do it?



View Replies !   View Related
How To Change Password To Dts Package Programmatically?
Hi,
 I was wondering if it is possible to change the password on a SQL Server 2000 DTS package programatically instead of justmanually using the the interface?
 I have over 150 DTS packages  used for building BI data cubes and our password policy requires a password change every 60 days.
I would like to write a windows vb.net application that loops through all the DTS packages and changes the password.
 Please advise.
 Thanks
 Chris

View Replies !   View Related
Change Mdf To Sql Authentication
I have a web app, designed using VWD Express and using SQL 2005 Express. It has a mdf database called "client". It was created using security of windows authentication. I have already changed my instance of sql server express to accept mixed windows and sql authentication.
 How do I change my "client" database's permissions to the sql authentication? I need to add a user name and password as a requirement for my web host to be able to attach the mdf to their instance of sql 2005. It has to be the same user and password as I use with my web host's sql server 2005.
Thank you in advance.

View Replies !   View Related
Change Authentication
I am not good endlish. I am thai.

I try to change authentication from win --> sql authen. I am use sql express and management tool.I amselect at .sqlexpress --> property -->security and change authentication from win authentication to sql authentication and click OK

after that re-connect and change to sql authentication but It notwork.

Pls tell meHow to change authentication.

Thank you for you help



View Replies !   View Related
To Change The Authentication Mode
Dear All..
            I am using sql server 2005 , the problem with me is that I want to change my Authentication type.... now It has setted as 'Windows Authentication and Sql Server Authentication', Here I wants to change to 'Sql Server Authentication' Only... Can I do it without re-installing my sql server... I did try by going Securiy Tab in properties of my server... there are two options 1)Windows Authentication 2)Sql Server and windows Authentication mode,   I want to change it to only Sql server Authentication....meaning to say - shld ask for authentication whenever log on to server
hope any one can help me
Thanks in Advance
Akbar

View Replies !   View Related
How Do I Change The Authentication Mode?
Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
to "Mixed Mode (Windows Authentication and SQL Server Authentication)".


How do I do this?

View Replies !   View Related
SQL Authentication Error On Password Change
I have instaled SQL Server2000 in Administrator user login.My OS is Windows Adavance Server2000. It works Fine. If i change my Administrator Password and Login with the new Password then Sql Server dosn't Run.It says Authentication error if i try to run from service.
I belive DBA's in this forum can help me out.

View Replies !   View Related
Change Authentication Type Problems
I am trying to change the authentication type for sql 2005, since a certain program is failing on databases that were created in sql 2005 (it works for the ones that were migrated from 2000). For some odd reason it is that it "cannot open database xxxYYY requested by the login. The login failed. The login failed for user Chris-Intelchris". I am not sure why this happens because when I check the security of the databases that user is the dbo for that database with the db_owner role. The only reason that I am trying to change the authentication type is that in a Microsoft bug fix it says to do it, so I am kinda grasping at straws.

When I try to change the type I get an error of:
Operation is not valid due to the current state of the object. (SqlManagerUI)

I have tried to shut everything down thinking that that was the problem, but that did not work.

What can I do to fix this?

Thanks

View Replies !   View Related
SSIS: Cannot Change Authentication From Win Auth
Full subject line would be "Integration Services: cannot change the Authentication from Windows Authentication"

"Why is it that when connecting to Integration Services I cannot change the Authentication from Windows Authentication? I have created specific SQL Logins to allow programmers to work with the database but they are unable to work with Integration Services."

EDIT: this question comes from the System Administrator of my SQL Server 2005. We are trying to get to the point where I can see and work with SSIS packages in SQL Server Business Intelligence Development Studio.

2nd EDIT: as far as acronyms used on this forum, is it acceptable to "short" SQL Server Business Intelligence Development Studio to SQL Server BIDS?

View Replies !   View Related
I Have SQL Authentication But Can Connect To SQL DBs Without Being Asked To Log In. I Need To Change This.



Hello, I have several SQL 2000 logins on our servers. I removed the builtin/ groups and only have SQL authentication users, although the server is operating in "Mixed Mode". How can I secure this? I don't understand how we can just connect to any DB without ever being asked to log in. Let me know if you can help. Thanks.

View Replies !   View Related
Need To Change Authentication Type Of My First DB In SQL05
* I was able to configure and install the DB

* I accidentally selected Windows Authentication



Now it won't let me login and keeps giving me an error.



Question: how do i change the authentication type without getting into the db? is there something I'm missing?

View Replies !   View Related
Need To Change Developers Acct To Windows Authentication
I have my SQL 7.0 server set for Mixed security. I see now (finally)the advantages of having windows authentication security for windowsgroups.I do most of my developing in Access Projects which require a login ofsome type. I have been using my SQL login to develop with SQL andthen when I give it to the user, I set the project to use Windowsauthentication. I want to be able to have Windows authentication onmy domain account but the user name for my windows account is the sameas my SQL account and it won't let me change the existing account.Now what happens is after I develop the product I have to have theuser login and go in and change to windows authentication. It won'tlet me do it with my sql account.I fear that if I delete my sql account and create a windowsauthentication account all the views, sps, etc. that I have createdwill still have the reference to the sql login and therefore not work.Do I need to have a generic sql account for developing? One thought Ihad was to create a new domain account so I can create that windowslogin and at least get my most recent projects working like I want to?Hope this makes sense to someone.Thanks in advance for your time.Sherry

View Replies !   View Related
Change Authentication Method In A Local Database File
I have made a small asp.net project which uses a local database file as a part of the project. The project is running fine om my local machine, but when I upload it to the remote server, the login fails for the server.

I suspect this is can be solved by using sqlserver authentication. But I have now spent a lot of time trying to configure the database file to use this authentication mode. As I see it there are three possible solutions to the problem.



use management studio express to configure the local mdf file (Ecxept that I cant find out how to connect to the mdf-file) and from here change the authentication method to sqlserver authentication.
use Visual Web developer to change the authentication method (but how???)
make the windows authentication work on the server (this would probably require that mannamgement studio express connects to the remote database. (Same problem as no 1)

Help will be higly appreciated.





Bjarke

View Replies !   View Related
Web Part Deserialization Error When Trying To Change Report Viewer Web Part Programmatically.


I have SSRS 2005 SP2 configured to work in Sharepoint integration. Everything works fine except that I am not able to programmatically change any property of report viewer web part (instance) that I have added on on home page of my sharepoint site.
I can do same thing via sharepoint UI but not through program. When my programs runs it fetches all web parts been added on home page, then I need to iterate through each one and find report viewer web part.
While iterating, assoon as I arrive to report viewer web part itis named as "Error web part" with error message as
"Windows SharePoint Services cannot deserialize the Web Part. Check the format of the properties and try again"

If someone has a solution, please respond at your earlist.

Thanks

Shankar


View Replies !   View Related
Report Server Authentication Errors (custom Security Authentication)
This has been plauging us for a year now and still haven't figured it out. We wrote a custom authentication extension based completely off the example code MS provided with SQL Server 2005. We upgraded to SP2 thinking it might fix the problem. Nope... here is what happens... you go to our server and there is a pause for about 5 seconds then the login page shows up I login with a user and pass then it just sits there with the loading icon spinning in IE. Eventually (this happens every time!) it comes back with




Code Block
"The report server is not responding. Verify that the report server is running and can be accessed from this computer. "


If you refresh that page it loads fine! ok seems odd... went ot the LogFiles folder and there is a minidump and a bunch of logs around the time that happened. Open ReportServerWebApp's log file and I get this




Code Block

Microsoft SQL Server Reporting Services Version 9.00.3161.00
en-US
Eastern Daylight Time
C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerWebApp__10_31_2007_13_49_48.log
NODEC
Microsoft Windows NT 5.2.3790 Service Pack 2
5.2.3790.131072

w3wp!library!1!10/31/2007-13:49:49:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!10/31/2007-13:49:49:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!10/31/2007-13:49:49:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!10/31/2007-13:49:49:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!10/31/2007-13:49:49:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!10/31/2007-13:49:49:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!10/31/2007-13:49:49:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!10/31/2007-13:49:49:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!10/31/2007-13:49:49:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!10/31/2007-13:49:49:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!10/31/2007-13:49:49:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!10/31/2007-13:49:49:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!10/31/2007-13:49:49:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!10/31/2007-13:49:49:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!10/31/2007-13:49:49:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!1!10/31/2007-13:49:57:: e ERROR: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
w3wp!ui!1!10/31/2007-13:49:57:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.ReportingServices.UI.Global+RSWebServiceWrapper+CantCommunicateWithReportServerException: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!10/31/2007-13:49:59:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)




Clearly showing there is an error that the server isn't responding... ok more log info on this in the SQLDmp log file that says




Code Block
Microsoft SQL Server Reporting Services Version 9.00.3161.00
en-US
Eastern Daylight Time
C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServer__10_31_2007_13_53_27.log
NODEC
Microsoft Windows NT 5.2.3790 Service Pack 2
5.2.3790.131072

w3wp!webserver!6!10/31/2007-13:53:27:: i INFO: Reporting Web Server started
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!6!10/31/2007-13:53:27:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!6!10/31/2007-13:53:27:: i INFO: Reporting Services starting SKU: Standard
w3wp!resourceutilities!6!10/31/2007-13:53:27:: i INFO: Evaluation copy: 0 days left
w3wp!resourceutilities!6!10/31/2007-13:53:27:: i INFO: Running on 2 physical processors, 4 logical processors
w3wp!runningjobs!6!10/31/2007-13:53:27:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!6!10/31/2007-13:53:27:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!6!10/31/2007-13:53:27:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!6!10/31/2007-13:53:27:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!6!10/31/2007-13:53:27:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.DispatchRequest(Boolean& transferedToViewerPage)
at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)
--- End of inner exception stack trace ---



says there is a ReportingServices.Diagnostics.Utilities.InternalCatalogException, well when I step through the code in the debugger this happens in a region I can not step through... and in my IIS logs I have this




Code Block2007-10-31 17:54:30 W3SVC1 10.10.2.15 GET /reports/Pages/Folder.aspx - 80 - 10.10.9.16 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506.30;+.NET+CLR+1.1.4322;+.NET+CLR+3.0.04506.590;+.NET+CLR+3.5.20706) 302 0 0
2007-10-31 17:54:32 W3SVC1 10.10.2.15 GET /Reports/Pages/UILogon.aspx ReturnUrl=http%3a%2f%2freschsql%2freports%2fPages%2fFolder.aspx 80 - 10.10.9.16 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506.30;+.NET+CLR+1.1.4322;+.NET+CLR+3.0.04506.590;+.NET+CLR+3.5.20706) 200 0 0
2007-10-31 18:01:10 W3SVC1 10.10.2.15 POST /reportserver/ReportService2005.asmx - 80 - 10.10.2.15 - 500 0 0
2007-10-31 18:01:10 W3SVC1 10.10.2.15 POST /Reports/Pages/UILogon.aspx ReturnUrl=http%3a%2f%2freschsql%2freports%2fPages%2fFolder.aspx 80 - 10.10.9.16 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506.30;+.NET+CLR+1.1.4322;+.NET+CLR+3.0.04506.590;+.NET+CLR+3.5.20706) 200 0 0
2007-10-31 18:01:41 W3SVC1 10.10.2.15 POST /reportserver/ReportService2005.asmx - 80 - 10.10.2.15 - 200 0 0
2007-10-31 18:01:41 W3SVC1 10.10.2.15 POST /Reports/Pages/UILogon.aspx ReturnUrl=http%3a%2f%2freschsql%2freports%2fPages%2fFolder.aspx 80 - 10.10.9.16 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506.30;+.NET+CLR+1.1.4322;+.NET+CLR+3.0.04506.590;+.NET+CLR+3.5.20706) 302 0 0
2007-10-31 18:01:47 W3SVC1 10.10.2.15 POST /ReportServer/ReportService2005.asmx - 80 - 10.10.2.15 - 500 0 0
2007-10-31 18:02:23 W3SVC1 10.10.2.15 POST /ReportServer/ReportService2005.asmx - 80 - 10.10.2.15 - 500 0 0
2007-10-31 18:02:24 W3SVC1 10.10.2.15 GET /reports/Pages/Folder.aspx - 80 - 10.10.9.16 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506.30;+.NET+CLR+1.1.4322;+.NET+CLR+3.0.04506.590;+.NET+CLR+3.5.20706) 302 0 0
2007-10-31 18:02:25 W3SVC1 10.10.2.15 GET /Reports/Pages/UILogon.aspx ReturnUrl=http%3a%2f%2freschsql%2freports%2fPages%2fFolder.aspx 80 - 10.10.9.16 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.04506.30;+.NET+CLR+1.1.4322;+.NET+CLR+3.0.04506.590;+.NET+CLR+3.5.20706) 200 0 0










Anyone have ANY idea of what is going on here? This is really a big problem for production code to lag and throw back timeout errors everytime someone wants to run a report. Thanks!




View Replies !   View Related
SQL Server Authentication Vs Windows Authentication
Would anyone please help me out here. which of the 2 modes of authentication is better and why??

View Replies !   View Related
Windows Authentication Vs SQL Server Authentication


For using different services of SQL SERVER 2005 which is better...
Windows Authenticationor SQL Server Authentication?
what are the advantages and disadvantages of both?

View Replies !   View Related
Report Manager With Forms Authentication. Report Server With Windows Authentication.
Hi.

I wonder if it is possible to set forms authentication for report manager but leave report server "as it is". I need to authenticate users from external LDAP and can't use windows authentication for report manager, but I would also like to leave report server open for anonymous users. In that way authenticated administrators could create reports which anonymous users could read.

I tested the Security Extension Sample and got it working when I rewrote the authentication part with my own LDAP authentication.

If I have understood correctly, the report manager is just application inside report server so is it possible to use forms authentication with one application but still leave the report server with Windows authentication?

View Replies !   View Related
NT Authentication / SQl Server Authentication
Hi,

I need to figure out what kind of Authentication , I need to use for following applicaiton

Product : -

1 ) It resides on a its Domain and has access to Database on that Domain.
2 ) We have a application level login , n based on application login id
display specific pages.

The question that bother me is this

Q ) If i use NT authentication , then a user will be required to

a ) Login to domain (with userid and password) first and then

b ) Then i would require to again login to applicaiton with application
level login and password.(different levels of login as there)
Based on the application level login i will display only specific
asp pages. They have different access rights..and roles.

Requirment is to login only once..and it should authenticate to application display specific pages and authenticate to SQl server database also..

Is there any way thru which i can map my application level login to SQl server.. and what authentication should i use..

Thanks,
Teny

View Replies !   View Related
Programmatically DTS Something To A SQL Server Instance?
i.e. ... PocketPC -> Laptop (MSDE) -> Ford website (SQL Server)


I don't even know where to begin. Please Help!

View Replies !   View Related
How Can I Connect To SQL Server 2005 Analysis Services Server Programmatically?
Hi, all here,

Would please anyone here give me any idea about how can I connect to SQL Server 2005 analysis services server and send XML request to it programmatically (with Business intelligence development studio in SQL Server 2005)? Thanks a  lot.

With best regards,

Yours sincerely,

View Replies !   View Related
SQL Sever 2005 Express Move Windowns Authentication Choice To Mixed Authentication
I folks.I Have installed sql server 2005 express and choosed windowsauthentication on instalation, but i make a mistake and now i needmixed authentication, how can i modify this whithout uninstall andinstall again the application?thanks for the help.

View Replies !   View Related
How To Create SQL Server Express Server (INSTANCENAME) Programmatically?
In deploying SQL Express, how do I create a new server (INSTANCENAME)programmatically?What would be the best approach to accomplish this.Thank you so much,

View Replies !   View Related
How To Create A New DB On A Remote Server Programmatically?
hi
my domain is hosted on a remote server
related databases are stored on a seperated DataServer
I have the name of that DataServer
and i need to create new DBs programmatically
 
I use this statement on my local machine 
sqlstat= "CREATE DATABASE dbc_" + dbid + " ON PRIMARY" + "(Name=db_" + dbid + ", filename = '" & Server.MapPath("~/app_data") & "" + dbfilename + "')"
but it will not work , because i dont know the physical path
i cant use Server.MapPath()
 
How could i do?
 
thanks

View Replies !   View Related
Programmatically Test Sql Server Connection
Hello all,
I am working on an administrative level screen for an ASP.NET application. I am using the enterprise library configuration block to read/write configuration data. One of the configuration items is the database connection string. What is the best way to take a given sql server connection string and test it to see if I can actually connect to the database with it?
 
Thanks!

View Replies !   View Related
Run SSIS Programmatically In 32-bit Mode On 64-bit Server


Environment:


Windows Server 2003 64-bit

SSIS 32-bit & 64-bit installed

.NET 2.0 application (Platform target x86) which executes an SSIS package programatically (using Microsoft.SQLServer.ManagedDTS.dll)
The issue I am having is that we connect to a Sybase server and even though the .NET app is executing in 32-bit mode, the SSIS pack appears to try load Sybase 64-bit OLEDB drivers.

The error I receive is DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER


When I run on a 32-bit machine all runs fineor if I run using the 32-bit version of DTEXEC the package also runs fine.


Any ideas on how I can force SSIS to use 32-bit drivers when run on 64-bit server programatically?

View Replies !   View Related
Switching SQL 2005 Authentication Mode From Windows To SQL Authentication
Hi there,I have installed MS SQL Server 2005 on my machine with windows authentication. But now I want to switch the authentication mode to SQL Authentication. I am unable to switch, I can’t find the proper way to do so here in 2005.Could any one help me in doing this?Thank you,-Ahsan

View Replies !   View Related
Exporting And Importing Sql Server Data Programmatically
I have a web application I created in asp.net + sql2005 and am deploying a genercized version of it to multiple clients. I have created a script which dynamically generates a database to a server and creates all of the tables, procs, and views. I now need data from the old database, which will be imported into the new database. It's basically default users, lookup values, etc. What are some methods of getting this data out of the old server and into the new server? I was thinking about generating flat files with the data, then writing code to loop through and insert the data, but it seems very tedious. Do I have any other options? I cannot use Backup and Restore because I have no access to the new sql server's filesystem.Thanks. 

View Replies !   View Related
Programmatically Set Linked Server Properties + SQL 2005 + RPC / RPC OUT


Hi Folks,

In SQL 2005, the linked servers are not automatically enabled for RPC / RPC OUT like they were in SQL 2000.I have set the properties for my linked server by using SQL Management Studio.

I right clickon the Linked Server --> Properties--> Server Options

There are options like: Collation Compatible,Data Access, RPC, RPC OUT, Use Remote Collation

There is a drop down box to set each value to TRUE or FALSE. Setting them through management studio works great, however for the production environment I need to set these properties programmatically. Is there a stored procedure or registry setting that would allow my program to set these values for a given linked server?

Thank you.



View Replies !   View Related
Import Flat File To Sql Server Programmatically
Hi,

i want to import flat file data to sql server. i created a package in vb.net. if the import table column is identity means i got

Failure inserting into the read-only column "ID".
Column metadata validation failed.
"component "OLE DB Destination" (10)" failed validation and returned validation status "VS_ISBROKEN".
One or more component failed validation.
There were errors during task validation. error.

how can i rectify this error? or how can i ignore the identity column in coding.



thanks & regards,

sivani





View Replies !   View Related
Using SQL Server 2000 Export Wizards Programmatically By Using VB.NET 2003
Hello,

Is there possibility to use export wizard programmatically ?

I need to copy the database structure (New db based on existing with alll constraints and relationships) ?

Thnx

View Replies !   View Related
Setup SQL Server Report Service (SSRS) Programmatically
Hi Everybody.



I really hope that someone can help me outon this mission.



I just started with SQL Server 2005 intensely, especially SSRS (Report Service). So far I battled my way through and succeeded. The project has been finished except for the setup/installation part.

I know that I can make use of the .ini file and add parameters to the SQL setup.



So my question is; if its possible to write an application, preferable in VB.NET 2005, which will setup the SQL Server Report Service (Reporting Services Configuration), deploy the Report Model to the Server and deploy the Reports to the Server, programmatically in other words.

All this needs to be done locally, so there is no need to be able to do it remotely from another PC.



Please, can anyone help me? Ive bean struggling with this for quite some time now, so any help will be greatly appreciated.

Thanks,

View Replies !   View Related
Sql Authentication = Fast./ Windows Authentication = V.slow!
Hello,

(Using win2k, sqlserver2k, framework 1.1)
I have an fairly data-heavy application that uses Windows authentication (Trusted connection/aspnet account) to connect to Sql Server. The site uses IIS basic authentication.

On the dev server everything works fine but when I move to the live server things get strange and it starts to crawl along. (Pages load OK but then it just crawls as it loads the datagrids etc. Sometimes it brings back incomplete/incorrect data )

BUT When I use Sql Authentication to connect to Sql Server and there is no problem at all!

Ok, there is something obviously wrong with the live server (which is identical setup to dev)but I dont know where to start.

Any ideas??

View Replies !   View Related
Using SQL Authentication And Windows Integrated Authentication Concurrently
Hi all,

I've got two applications which both have a database on my MS SQL 2000 server. The problem is, one application must use Windows Integrated Authentication (which it is currently using and cannot be changed) whilst the other application which I'm trying to configure must use a SQL password.

Since the server has already been configured to use Windows Integrated Authentication for the existing database and application, how do I configure the other database to use the SQL password?

Thanks.

View Replies !   View Related
Authentication An Application Using Windows Integrated Authentication
Hi all,

My work is using a shared application
which accesses a MSSQL 2000 database. To access the application, the
folder on the Windows 2003 Server is shared and users can access the
folder through a shared drive.


For the application to access the
database, it uses an ODBC connection to the MSSQL server which
originally used the SA password.


We have recently switched to using
Windows Integrated Authentication because we believe it offers a
higher level of security. However the only way in which we have been
able to enable this is to add the windows users to the SQL server.


The problem with this is that the
application sets permissions for individual users on what records
they can see within the database. We have found that by adding the
windows users to the SQL Server, they can bypass the permissions the
set by the application by simply using any application that can use
an ODBC connection, such as Enterprise Manager, and see all the
database.

One way around this would be to set up
domains of users with access privileges to the tables which reflect
the permissions set by the application, and configuring a view of the
data so they may only see the records that they have permissions to.
However to do this would require a high administrative cost to ensure
that changes made in the application are reflected in the privileges
of the SQL server.

Instead, is there a way the SQL server
can authenticate that the ODBC connection is coming from the correct
application using Windows Integrated Authentication?

This would allow the applcation to
determine security, and stop users from connecting to the SQL server
using other applications.

Alternatively, can the SQL server,
using Windows Integrated Authentication, also ask the application to
supply a username and password?

Any help with this matter would be
greatly appreciated.

Thanks!

View Replies !   View Related
Running A Package Programmatically On The Server By Using A Web Service Or Remote Component
Hi,

I am trying to apply the sample provided by Microsoft in the following article:

http://msdn2.microsoft.com/en-us/library/ms403355.aspx

I am trying to call a SSIS package from a web service hosted on the same machine as the package file is sitting. The package is running fine from the Agent and also by the "Integration Services Project" in VS.NET.

I had a lot of problems with permissions but they are resolved, at least I have no error messages to point to that direction. Now I am getting these results:

1. Error: -1073659874 / Description: The file name "\Diver-svrInputDataFilesdn_cust.txt" specified in the connection was not valid.

2. Error: -1073659875 / Description: Connection "bdn_cust" failed validation.

3. Error: -1073659874 / Description: The file name "\Diver-svrInputDataFilesdn_cust.txt" specified in the connection was not valid.

4. Error: -1073659875 / Description: Connection "SourceConnectionFlatFile" failed validation.

Where \DiverMInputFilesdn_cust.txt" is a file processed by the package.

Is there anybody who can give me some directions.  Thank you in advance.

 

 

 

View Replies !   View Related
How To Programmatically Reschedule/schedule Jobs In Server 2000 And 2005 ?
Hi,

how to reschedule/schedule jobs in server 2000 and 2005 Programmatically?

thanks

sandipan

View Replies !   View Related
Programmatically Assigning The Datasource In The Server Report Ssrs 2005
Dear All:

I am new to SSRS 2005.

I have created many shared datsources and reprots at http://localhost/resportserver.


I am trying to access these reports from ReportViewer in the web application. Actually I want to use these reports for different customers by just changing the datsource programitically.

Is this is a possible?

Thank you
Theju


View Replies !   View Related
Switching From SQL Authentication To Integrated Authentication?
Hi,I'm using SQL Server 2005. My Connection String looks like that at the moment: <add name="LocalSqlServer" connectionString="Data Source=xx;Initial Catalog=xx;Persist Security Info=True;User ID=xx;Password=xx" providerName="System.Data.SqlClient"/>    Now I'd like to change this kind of authentication to Integrated Windows AuthenticationI added the WorkerProcess IIS_WPG to the permitted Users but it didn't help.Changed the Connection String to this:connectionString="Server=xx;Database=xx;Trusted_Connection=True;"All I'm getting is that my NetworkService is not permitted to access DB when I try to connect to the DB in ASP.NET.How can I properly configure that? Thanks!

View Replies !   View Related
Difference Between Sql Authentication And Windows Authentication
Hello

Can anyone tell me what is the difference between sql authentication and windows authentication.

Examples of each would be very useful

Many thanks in advance

Steve

View Replies !   View Related
Using Windows Authentication V/s Mixed Authentication
Hi,

Say, I have configured my SQL to use Mixed Authentication. Now, I have a applicaiton which uses my SQL Server. The application just creates a database in SQL Serverand uses the database to store its information.

This application also has a SYSTEM DSN under ODBC through which it accesses the database. For the application to access this database, should I only use SA (as my SQL instance is configured to use Mixed Authentication) or can I use Windows Authentcation too...

If I should only use SA, do we have a documentation which talks about this.

Thanks
Santhosh

View Replies !   View Related
Cannot Upgrade MSDE 2000 Release A To SQL Server 2005 Express Using SQL Server Authentication


I'm trying to upgrade the Default Instance of MSDE 2000 Release A which is installed with Mixed Mode and strong password to SQL Server 2005 Express in a Windows 2000 Server with SP4. On the Upgrade Logon Information screen, if I select SQL Server Authentication Mode, it will give me this message:

SQL Server Setup Cannot Upgrade the specified instance by using SQL Server Credential. You must use Windows Authentication credential for the upgrade.

Thanks for any help.

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved