Authentication Error After Adding An Article
Feb 23, 2006
Hi
-- edited 26/02 to clarify the security model --
Using HTTPS merge replication
The subscriber was able to get the snapshot ok, then synchronise fine
However after adding an article to the publication and recreating the snapshot I get this error now at the subscriber
Microsoft.SqlServer.Replication.ComErrorException (0x80004005): A failure occurred when accessing 'usp_misc_dailyTasks_3.sch' due to an operating system error [2='The system cannot find the file specified.'] during Web synchronization. Ensure that the -InternetLogin user when using basic authentication and the user running the merge when using Windows integrated authentication has been granted access to the snapshot share.
at Microsoft.SqlServer.Replication.MergeSynchronizationAgent.Run()
The key properties when synchronising are as follows:
agent.PublisherSecurityMode = SecurityMode.Standard
agent.DistributorSecurityMode = SecurityMode.Standard
agent.InternetSecurityMode = SecurityMode.Standard
In order to create the subscription:
subscription.UseWebSynchronization = True
subscription.InternetUrl = webSyncUrl
subscription.InternetSecurityMode = AuthenticationMethod.BasicAuthentication
subscription.SubscriberType = MergeSubscriberType.Anonymous
subscription.SyncType = SubscriptionSyncType.Automatic
Thanks
Bruce
View 1 Replies
ADVERTISEMENT
Mar 27, 2008
how to add new article within the existing replication
View 1 Replies
View Related
Feb 11, 2005
Hi All,
I am having a server where replication is set up between 2 differnt databases. It is currently running. I want to add a couple of tables to the replication. I tried using sp_addArticle, but after executing it, in the properties of the publication it shows the new tables, but at the database level the tables are missing.
I tried with sp_addsubscription but I am getting strange error:
Server: Msg 14100, Level 16, State 1, Procedure sp_addsubscription, Line 240
Specify all articles when subscribing to a publication using concurrent snapshot processing.
What can I do to publish the tables into the target database?
Thanks in advance.
View 5 Replies
View Related
Sep 5, 2007
I have setup Transactional replication in SQL 2005 between two servers and have about 200 tables being replicated. The problem is that every time, I add or drop a table to replication, and start the Snapshot agent, it re-initializes every article and re-loads every article. This process takes 1 hour to complete and CPU usage goes to 100% during that time.
This behaviour seems very different from SQL 2000 where I would start Snapshot agent and only the relevant tables were added/dropped.
Has that functionality changed from 2000 to 2005? Am I not doing something right?
Thanks,
Amir
View 3 Replies
View Related
Aug 5, 2014
In my local environment , i was setup transnational replication then i have added new article by using below script
EXEC sp_changepublication @publication = 'demo', @property =
N'allow_anonymous', @value='TRUE'
Go
EXEC sp_changepublication @publication = 'demo', @property =
N'immediate_sync', @value='TRUE'
EXEC sp_addarticle @publication = 'demo', @article ='employee',
[Code]....
But article not added and showing this error message The initial snapshot for article 'employee' is not yet available.
What is the issue, what can i do to add new article ? What did I mistake?
View 2 Replies
View Related
Jul 13, 2006
First of all; My Oracle publication works fine when I don't explicit specify the shema_option parameter for the articles I'm adding to the publication. The reason why I then want to explicit specify the parameter is as following.
I'm developing a replication solution to get data from our production server (Oracle) to our Data Warehouse (SQL Server). The SQL Server (and the Data Warehouse code) uses the SQL_Latin1_General_CP1_CI_AS collation. When I don't explicit specify the schema_option, the nvarchar columns of the replicated tables are created using the SQL_Latin1_General_CP1_CS_AS collation and this results in some comparison errors, when for instance a select statement is trying to compare two nvarchar strings using different collations.
I've tried to specify the schema_option parameter as "@schema_option = 0x80" (Replicates primary key constraints.) to avoid the use of the SQL_Latin1_General_CP1_CS_AS collation when creating the destination tables - I'm not sure it's enough? No matter what, I'm getting an error when I'm doing it (see below).
Message
2006-07-13 12:00:15.529 Applied script 'ITEMTRANSLATION_2.sch'
2006-07-13 12:00:15.544 Bulk copying data into table 'ITEMTRANSLATION'
2006-07-13 12:00:15.544 Agent message code 20037. The process could not bulk copy into table '"ITEMTRANSLATION"'.
2006-07-13 12:00:15.591 Category:NULL
Source: Microsoft SQL Native Client
Number: 208
Message: Invalid object name 'ITEMTRANSLATION'.
2006-07-13 12:00:15.591 Category:NULL
Source:
Number: 20253
The questions are now whether I actually have a schema_option alternative for Oracle Publishing? If so, what is the solution, and eventually how can I avoid the error stated above?
If I'm not able to avoid the article columns getting created with the "wrong" collation, is there then any other obviously solution to the problem?
Thanks!
Best regards,
JB
View 5 Replies
View Related
Mar 9, 2006
Hi
Using merge replication - the stored procs are published articles.
When trying to change the article at the subscriber (sql express) I get the following errors:
Msg 21531, Level 16, State 1, Procedure sp_MSmerge_alterschemaonly, Line 45
The DDL statement cannot be performed at the Subscriber or Republisher.
Msg 21530, Level 16, State 1, Procedure sp_MSmerge_ddldispatcher, Line 181
The DDL operation failed inside merge DDL replication manipulation.
Msg 3609, Level 16, State 2, Procedure usp_Anniversary_upd, Line 21
The transaction ended in the trigger. The batch has been aborted.
Does this mean it can only be changed at the publisher ?
Bruce
View 5 Replies
View Related
Jan 16, 2007
Hello, I have run into a strange problem with RS 2000. I have a base class that will call a reporting server web service, render a report to pdf, then write the report output to the stream. This has worked fine for me for reports.
However, when I render a graph to pdf, I get the following exception:
[ArgumentException: cookie.Domain]
System.Net.CookieContainer.Add(Cookie cookie) +583
Learning.Common.Reporting.ReportServerProxy.GetWebRequest(Uri uri)
...
I only get this exception in our staging environment, not locally.
Here is a code snippet from the ReportServerProxy class, but it is pretty textbook according to the MSDN samples..
public class ReportServerProxy : ReportingService {
protected override WebRequest GetWebRequest(Uri uri) {
HttpWebRequest request;
request = (HttpWebRequest)HttpWebRequest.Create(uri);
// Create a cookie jar to hold the request cookie
CookieContainer cookieJar = new CookieContainer();
request.CookieContainer = cookieJar;
Cookie authCookie = AuthCookie;
// if the client already has an auth cookie
// place it in the request's cookie container
if (authCookie != null){
request.CookieContainer.Add(authCookie);
}
...
}
As I said, I can run reports one after another without issue, graphs are causing me problems.
View 1 Replies
View Related
May 5, 2008
Hi Guys:
Our company wanted to try out SQL Server 2005 Enterprise Edition (64 Bit). So, we were on free trial of the Enterprise Edition for past 5 months. After which we decided to go for SQL SERVER 2005 Standard Edition (64 Bit). And, Last week, we installed the SQL Server Standard Edition (64 Bit) on our server. After installation, everything was restored as before.
The version we are on right now is:
Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Strangely, a job which ran fine till then is failing with the following error: And, to be more specific, when this job is run manually in the form of a stored procedure using the query optimizer it runs fine. But, when its executed as a scheduled job on SQL Agent, it fails. The History logs record the following error.
Error :
The OLE DB provider "SQLNCLI" for linked server "LV-SQL2" reported an error. Authentication failed. [SQLSTATE 42000] (Error 7399) Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "LV-SQL2". [SQLSTATE 42000] (Error 7303) OLE DB provider "SQLNCLI" for linked server "LV-SQL2" returned message "Invalid authorization specification". [SQLSTATE 01000] (Error 7412).
I tried everything possible, even recreated the job, but, no avail.
I also considered the possibility if SQL Agent login account did not have enough permissions. So, I changed the SQL Agent login to windows authentication, but the job still fails. So, its the problem has nothing to do with login accounts either.
For the record, I have cross checked all these too.
1. Enabled the remote connections in Surface Area Config
2. Added local server login to remote server login mappings.
3. Checked 'Rpc' and 'Rpc Out' under server options. Also, the Connection Timeout and Query Timeout have been set to zero (0).
Any suggestions pointing towards problem solution appreciated.
Thank you.
View 4 Replies
View Related
Apr 3, 2008
I have managed to get the Forms Authentication sample to work bu there is a hitch. I am running Report Server and Report Manager on the same(test) PC. I can logon to the Report Server without a problem but when I try logon from the UILogon.aspx page for Report Manager I receive the following error:
An error occurred while attempting to get the ReportServer Url. The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
An error occurred while attempting to get the ReportServer Url. The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)An error occured while attempting to get the ReportServer Url. The RPC server is unavailable.(Exception from HRESULT: 0x800706BA).
I can register users which suggests that the page can connect to the database.
Any help???
View 3 Replies
View Related
Apr 2, 2007
Hi Everybody,
I'm very new to .NET programing and my database is SQL Express edition.i'm using Visual Studio 2005.i'm trying to execute a simple application that basically select data from a employees table and display it to label on a webpage. when i run the application i'm getting the following error and i don't know how to fix.i'm using windows integrated authentication to logon to SQLEXPRESS instance. and the service is by default running under NT AUTHORITYNetwork Service account.I'm try to use visual studio default web server not IIS webserver, so i think i don't need an ASPNET account.but i'm not sure.could anyone help please.
Cannot open database "Dorknozzle.mdf" requested by the login. The login failed.Login failed for user 'BOND
ed.
Source Error:
Line 12: Dim comm As New SqlCommand("select employeeid,name from employees", conn)
Line 13: 'open connection
Line 14: conn.Open()
Line 15: 'execute the command
Line 16: Dim reader As SqlDataReader = comm.ExecuteReader()
Source File: C:Documents and Settings
eddyMy DocumentsVisual Studio 2005WebSitesHelpdeskDefault2.aspx Line: 14
i got SQL Server Mangement Studio Express Installed to manage the server.please help me
regards
RED
View 10 Replies
View Related
Jun 6, 2007
Hi ,
I was trying to run my application that has to Synchronize data between sql mobile and sql 2005. In the emulator all is fine and executes without any error.But when I deploy the application in real device it throws an exception:"Authentication failed in server running IIS". The device is WM5.0
The connection string is like this.
String strRemote = "Provider=SQLOLEDB;Data Source=servername;User ID=userid;Password=password;Initial Catalog=databasename";
I am getting the exception only when the application is deployed in the device.
The error log in C:inetpub/wwwroot/Sync is the following:
2007/05/25 12:54:29 Hr=00000000 SQLCESA30.DLL loaded 0
2007/05/25 12:54:29 Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1
2007/05/25 12:54:58 Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1
2007/05/25 12:57:00 Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1
2007/05/25 13:00:37 Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1
2007/05/25 14:55:07 Hr=00000000 SQLCESA30.DLL loaded 0
2007/05/25 14:56:10 Thread=1534 RSCB=2 Command=SCHK Hr=80040E2F The statement has been terminated. 3621
2007/05/25 14:56:10 Thread=1534 RSCB=2 Command=SCHK Hr=80040E2F Violation of PRIMARY KEY constraint 'PK_Orders'. Cannot insert duplicate key in object 'dbo.Orders'. 2627
2007/05/25 19:19:20 Hr=00000000 SQLCESA30.DLL loaded 0
2007/05/25 19:19:20 Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1
2007/05/25 19:20:12 Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1
2007/05/25 19:21:27 Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1
2007/05/25 19:21:47 Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1
Please reply....
View 1 Replies
View Related
Jul 21, 2007
I am getting this error when I try to switch the SQL Express installation from Windows to SQL Auth. "Operation is not valid due to the current state of the object".
Short of uninstalling and then reinstalling I don't know how to resolve it. Suggestions?
View 1 Replies
View Related
Aug 22, 2007
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 2 Replies
View Related
May 11, 2007
How to give authentication for Send Mail Task component?
View 4 Replies
View Related
May 30, 2005
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 2 Replies
View Related
Jul 20, 2005
Hey Gang, I get a error message "Authentication Failed for SQL Serverinstance: local with friendly name local SQL Server does not exist oraccess denied". I have a Just loaded SQL Server on my virtual box and loadedMicrosofts bpa and microsoft security anlyzer. The security scan work but thebpa scan doesnot. I also look at the database,I can get access to and notice a newdatabase schema(sqlbpa). Any help would be appreciated.ThanksGarry D
View 2 Replies
View Related
May 10, 2006
This is the strangest thing. Whenever I try to access report builder from 90% of machines, I get the following error:
PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
SOURCES
Deployment url : https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [5/10/2006 8:48:02 AM] : Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application has started.
ERROR DETAILS
Following errors were detected during this operation.
* [5/10/2006 8:48:11 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
COMPONENT STORE TRANSACTION DETAILS
No transaction informtion is available.
-------------------------------
Ok, so here's the catch. It works one 1 machine, a co-workers machine. I can login as any user and it'll work fine. But when I try it on any other machine, including my laptop, my desktop, my server, etc. I get that error. I've tried adjusting the IE Security settings, firewall settings, even tried different browsers. Here's some of the stuff installed on my machines:
Laptop
-Windows XP Pro
-ASP.NET Validation Tool
-Visual Basic Express w/ SQL Server Express
-.NET 1.1/2.0 Framework
Desktop
-Windows XP Home
-Visual Studio 2005 Professional
-.NET 1.1/2.0 Framework
Server
-Windows Server 2003 Enterprise
-SQL Server 2005
-.NET 1.1/2.0 Framework
Any help on this would be greatly appreciated. Even our lead developer has no clue, it won't work on his machine either!
View 1 Replies
View Related
Mar 11, 2008
I got Form Authentication to work, but I am getting this error sometimes. To reproduce this error consistantly is to run iisreset.exe to have a fresh start. Go to my report server login and open any report.
The page will display: The remote server returned an error: (500) Internal Server Error.
If i click "F5" to refresh the page the report will show up or if you go to another report it will work also. It is just the first time after iisreset.exe. It is very strange.
Here is my log file:
aspnet_wp!library!6!03/11/2008-15:20:36:: i INFO: Exception dumped to: c:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!6!03/11/2008-15:20:47:: Call to GetPermissionsAction(/).
aspnet_wp!library!1!03/11/2008-15:20:47:: Call to GetPropertiesAction(/, PathBased).
aspnet_wp!library!6!03/11/2008-15:20:48:: Call to GetSystemPermissionsAction().
aspnet_wp!library!1!03/11/2008-15:20:48:: Call to ListChildrenAction(/, False).
aspnet_wp!library!6!03/11/2008-15:20:49:: Call to GetSystemPropertiesAction().
aspnet_wp!library!1!03/11/2008-15:20:49:: Call to GetSystemPropertiesAction().
aspnet_wp!library!a!03/11/2008-15:20:53:: Call to GetPermissionsAction(/Sentrack).
aspnet_wp!library!1!03/11/2008-15:20:53:: Call to GetPropertiesAction(/Sentrack, PathBased).
aspnet_wp!library!a!03/11/2008-15:20:54:: Call to GetSystemPermissionsAction().
aspnet_wp!library!1!03/11/2008-15:20:54:: Call to ListChildrenAction(/Sentrack, False).
aspnet_wp!library!a!03/11/2008-15:20:56:: Call to GetSystemPropertiesAction().
aspnet_wp!library!1!03/11/2008-15:20:56:: Call to GetSystemPropertiesAction().
aspnet_wp!library!6!03/11/2008-15:20:58:: Call to GetPermissionsAction(/Sentrack/Shared Reports).
aspnet_wp!library!1!03/11/2008-15:20:59:: Call to GetPropertiesAction(/Sentrack/Shared Reports, PathBased).
aspnet_wp!library!6!03/11/2008-15:20:59:: Call to GetSystemPermissionsAction().
aspnet_wp!library!1!03/11/2008-15:20:59:: Call to ListChildrenAction(/Sentrack/Shared Reports, False).
aspnet_wp!library!6!03/11/2008-15:21:00:: Call to GetSystemPropertiesAction().
aspnet_wp!library!1!03/11/2008-15:21:00:: Call to GetSystemPropertiesAction().
aspnet_wp!library!a!03/11/2008-15:21:04:: Call to GetPermissionsAction(/Sentrack/Shared Reports/Report).
aspnet_wp!library!1!03/11/2008-15:21:04:: Call to GetSystemPropertiesAction().
aspnet_wp!library!a!03/11/2008-15:21:05:: Call to GetPropertiesAction(/Sentrack/Shared Reports/Report, PathBased).
aspnet_wp!library!1!03/11/2008-15:21:05:: Call to GetSystemPermissionsAction().
aspnet_wp!library!a!03/11/2008-15:21:06:: Call to GetPropertiesAction(/Sentrack/Shared Reports/Report, PathBased).
aspnet_wp!library!1!03/11/2008-15:21:06:: Call to ListEventsAction().
aspnet_wp!library!1!03/11/2008-15:21:07:: Unhandled exception was caught: System.Web.HttpException: File does not exist.
at System.Web.StaticFileHandler.ProcessRequestInternal(HttpContext context)
at System.Web.DefaultHttpHandler.BeginProcessRequest(HttpContext context, AsyncCallback callback, Object state)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
aspnet_wp!library!1!03/11/2008-15:21:07:: 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.Web.HttpException: File does not exist.
at System.Web.StaticFileHandler.ProcessRequestInternal(HttpContext context)
at System.Web.DefaultHttpHandler.BeginProcessRequest(HttpContext context, AsyncCallback callback, Object state)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
--- End of inner exception stack trace ---
Any ideas?
View 3 Replies
View Related
Sep 26, 2006
Running a SQL 2005 Database under a Default instance. i.e. (SERVERNAME) and not (SERVERNAME/SQL2005)
View 3 Replies
View Related
Feb 20, 2007
Hello
I'm trying to get the forms authentication sample working - I have followed the instructions given in the ReadMe that came with the samples. When I try to browse to localhost/reportserver (on the server), instead of seeing the logon page as expected, I get the following error message:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
I built the sample in VS 2005, and am using v2 of .net. Reporting services is installed on a windows server 2003 machine.
This has been driving me crazy for a while now. Any help would be greatly appreciated!
Thanks in advance
Dominic
View 4 Replies
View Related
Feb 9, 2008
Hi,
I have just installed Windows Vista and SQL Server 2005. When I try to connect to my local server with Windows Authentication, I get the follwoing message:
Login failed for user <user> (Microsoft SQL Server, error: 18456)
Any help please. Thanks.
View 1 Replies
View Related
Apr 18, 2007
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 1 Replies
View Related
Oct 7, 2014
When I am trying to connect my database using SQL Server Authentication option, then its showing error: "An attempt to login suing sql authentication failed. Server is configured only for Windows authentication only."
View 8 Replies
View Related
Jul 20, 2005
I have an asp drive web page that writes a row to a table on sqlserver 2000. The web site is set to use windows authenication and thesql server is set to use windows authentication.This process works fine on windows xp sp 1 machines but on win2k sp4machines logged in as the same user i get the errorAn error occurred making the change -2147217843 Error connection toSQL Server: [Microsoft][ODBC SQL Server Driver][SQL Server]Loginfailed for user '(null)'. Reason: Not associated with a trusted SQLServer connection.can anyone explain why win2k client would have this issue and notwinxp clients?Glenn
View 1 Replies
View Related
Jan 11, 2007
Hello Experts,
I have a Report Server when i try to deploy my report on the same server and if i use the Fully Qualified Domain Name in my report path i get the below Error
TargetServerURL : http://jptoclq901.corpusers.net/ReportServer
Error : The request failed with HTTP Status 407 : Proxy Authentication Required (Microsoft.ReportingServices.Designer)
but if i use the TargetServerURL as http://localhost/ReportServer, things do work fine. but company requirement is to use complete path.
Is this a limitation or some way out, any Idea???
Thanks in advance for the help
/Soni
View 1 Replies
View Related
Apr 3, 2006
I got the following error using either NT or SQL Login ('sa') that are sysadmin in my SQL 2005 instance:
Your Account information could not be verified for one or more instances. Ensure that you can connect to all the selected instances using the account information provided. To process further deselect the instances to which connectivity cannot be established.
However, I would login to SQL 2005 named instance, either NT or SQL login 'sa' without any problems to do anything I want because both are sysadmin.
<PS> Note that my default SQL instance in my local server is SQL 2000 and SQL 2005 named instance.
Richard
View 4 Replies
View Related
Jun 5, 2007
Maybe someone can help me. I am running the reporting service add in for Sharepoint and we have only Basic Authentication running on our site (it is on SSL). When i try and open a report in sharepoint it errors out on me. When i go back into IIS and set Windows and Basic authentication it works, but it requires me to enter our domain and username. We need to only use Basic so it will not need the domain. Anyone have any suggestions on what i can do to make this work?
View 5 Replies
View Related
Feb 6, 2006
I'm working on an ASP.NET project, and we're attempting to switch from SQL Server authentication to Windows authentication to connect to the database.
It works fine locally when I debug in Visual Studio, but when it hits the web server, I get the error: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
IIS has anonymous access disabled, and Integrated Windows Authentication is checked. The web.config file has:
<authentication mode="Windows"/><identity impersonate="true"/>
The database I'm attempting to access is on a different machine than IIS, and the connection string doesn't contain a username or password, and has "Trusted_Connection=Yes", and "Integrated Security=SSPI".
From what I've been able to find online, I'm guessing the problem is due to IIS and SQL Server residing on different machines, but I'm not sure how to fix it.
Any ideas?
View 3 Replies
View Related
Jun 19, 2015
I'm trying to implement a SSAS Project in a Virtual Machine using a private network. When I try to deploy the solution the program gives me the following error:
I already have a Windows Authentication but still gives me that error.
View 3 Replies
View Related
Mar 25, 2004
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 2 Replies
View Related
May 15, 2006
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 1 Replies
View Related
May 12, 2006
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 4 Replies
View Related
