User profile for PDinCA

This is also logged in the uservoice feedback (http://redgate.uservoice.com/forums/944 ... -prompt-sh) - perhaps Paul's response solves that issue - I just found I have the SSMS Tools with the snippets enabled, which are now disabled... Thanks for the post Paul. / comments

This is also logged in the uservoice feedback (http://redgate.uservoice.com/forums/944 ... -prompt-sh) - perhaps Paul's response solves that issue - I just found I have the SSMS Tools with the snip...

0 votes

Thanks, Mike. I downloaded 5.3 yesterday and will try the synonym feature again. / comments

Thanks, Mike. I downloaded 5.3 yesterday and will try the synonym feature again.

0 votes

Well knock me down with a feather! Msg 18456, Level 14, State 1, Line 1 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Msg 18456, Level 14, State 1, Line 1 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Msg 18456, Level 14, State 1, Line 1 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Query RESULTS are OK, but the exception still occurs. object_id schema_id name base_object_name base_type 1339151816 1 t_meter_raw_source [xcProd1].[xcp_trans].[dbo].[t_meter_raw] NULL 1355151873 1 t_location_variable_ref_source [xcProd1].[xcp_trans].[dbo].[t_location_variable_ref NULL 2091154495 1 t_meter_clean_source [xcProd1].[xcp_trans].[dbo].[t_meter_clean] NULL The problem is due to LINKED SERVER definitions on the target Server. I decided to script out the Linked Server on BOX3 from BOX2. That Linked Server points to BOX1 on the SAME domain. I'd forgotten that to define or script-out THAT Linked Server def I need to be ON THE BOX. So, when I tried THAT with 5.2.2.1 BTW: =================================== Script failed for Synonym 'dbo.t_location_variable_ref_source'. (Microsoft.SqlServer.Smo) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0038+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Script+Synonym&LinkId=20476 ------------------------------ Program Location: at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(DependencyCollection depList, SqlSmoObject[] objects) at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(Urn[] urns, SqlSmoObject[] objects) at Microsoft.SqlServer.Management.Smo.Scripter.Script(Urn[] urns, SqlSmoObject[] objects) at Microsoft.SqlServer.Management.Smo.Scripter.EnumScript(Urn[] urns) at Microsoft.SqlServer.Management.Smo.Scripter.Script(Urn[] urns) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ScriptGenerator.ScriptCreate(SqlTextWriter sqlwriter, Server server, Urn[] urns, SqlScriptOptions options) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ScriptNodeActionContext.Script(SqlTextWriter writer) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SqlScriptMenu.OnScriptItemClick(Object sender, EventArgs e) =================================== Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (.Net SqlClient Data Provider) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.5292&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476 ------------------------------ Server Name: xcDev3 Error Number: 18456 Severity: 14 State: 1 Line Number: 1 ------------------------------ Program Location: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.HasMoreRows() at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.Read() at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query) at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm) at Microsoft.SqlServer.Management.Smo.ExecuteSql.ExecuteWithResults(StringCollection query, Object con, StatementBuilder sb) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult erParent) at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData() at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci) at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.InitializeKeepDirtyValues() at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithListWorker(DependencyCollection depList, SqlSmoObject[] objects) at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(DependencyCollection depList, SqlSmoObject[] objects) Very clear that Synonym to a linked-server is the culprit. The actual Synonym and Linked Server definitions are (obfuscated) CREATE SYNONYM [dbo].[t_location_variable_ref_source] FOR [BOX1].[DBtrans].[dbo].[t_location_variable_ref] EXEC master.dbo.sp_addlinkedserver @server = N'BOX1', @srvproduct=N'SQL Server' EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'BOX1',@useself=N'True',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'BOX1',@useself=N'False',@locallogin=N'THISDOMAIN\AppAdmin',@rmtuser=N'RawTransfer',@rmtpassword='########' EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'BOX1',@useself=N'False',@locallogin=N'THISDOMAIN\DBAdmin',@rmtuser=N'RawTransfer',@rmtpassword='########' GO (If the Linked Server def looks funky it's because it was left alone once working... [image] ) Apologies to Brian Donahue for overlooking the double-hop comment - this is that issue... :oops: / comments

Well knock me down with a feather!Msg 18456, Level 14, State 1, Line 1 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Msg 18456, Level 14, State 1, Line 1 Login failed for user 'NT AUTHORITY...

0 votes

Upgraded back to 5.2.8.2 and made sure Synonym feature in Experimental is OFF. All is well! Changed title of thread to SOLVED: As part of the development of the Synonym feature, please use case F0058243 and this thread as collateral to fix the bug for prime-time. Regards, Stephen. / comments

Upgraded back to 5.2.8.2 and made sure Synonym feature in Experimental is OFF. All is well! Changed title of thread to SOLVED: As part of the development of the Synonym feature, please use case F...

0 votes

Thanks, Mike. I'll install SQL Prompt on a different server on the same domain that can also access other servers/instances. I'll run 5.2.2 first, then 5.2.6 and run the synonym query. Will post when done... / comments

Thanks, Mike. I'll install SQL Prompt on a different server on the same domain that can also access other servers/instances. I'll run 5.2.2 first, then 5.2.6 and run the synonym query. Will post w...

0 votes

Same issue w/ 5.2.8.2 re-update. SQL then Windows login cleared it. Working... :roll: / comments

Same issue w/ 5.2.8.2 re-update. SQL then Windows login cleared it. Working... :roll:

0 votes

Added Pooling=false (pasted the exact phrase sans double-quotes from the post above) and I get snippets but ALL tables are missing. The same, original, error message appears connecting to ANY server with WINDOWS Authentication. EVERY server is on the same domain as the development server. I am 1 of only TWO Users connected to the server via RDP from W7 using TCP/IP, logging in with credentials on the Development Server's domain. I have logged off the box and logged back again. Ran Windows Update and rebooted the server, too. I took the DRASTIC step of using Revo Uninstaller to rip 5.2.8.2 off the box before the reboot, then installed 5.2.2 after the reboot and IT WORKS! Using Revo, I cleared all trace of the Experimental Features registry content, plus deleted all the config xml files. I am officially DEAD IN THE WATER WITH REGARD TO 5.2.6 and 5.2.8.2. Pity, because partial matching was VERY useful. Assistance hereby requested on Monday March 19th 2012. I'm on Pacific Time. Please email me with steps I can assist with debugging this catastrophic issue. Thanks. Box: Windows Server 2003 R2 Standard SP2 with all latest updates. 32-bit. At the time of writing, of the 3.5GB memory, 1.8GB is available. SSMS is 2008R2 targeting SQL2005EE instances. / comments

Added Pooling=false (pasted the exact phrase sans double-quotes from the post above) and I get snippets but ALL tables are missing. The same, original, error message appears connecting to ANY serve...

0 votes

Ran "Check for Updates" - NONE AVAILABLE! Used prior 5.2.8.2 download... / comments

Ran "Check for Updates" - NONE AVAILABLE! Used prior 5.2.8.2 download...

0 votes

Emailed you, Brian, the debug file content, which is clear of all exceptions: <?xml version="1.0" encoding="utf-8"?><RedFlagResults xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ProgramName="smss " OSVersion="Microsoft Windows NT 5.2.3790 Service Pack 2" DotNetVetsion="" Bitenss="32"><Exceptions /><Modules /><Messages /><AppDomainList /></RedFlagResults> Still need help, because this happens on every query window open and I need it gone so I can get some work done... / comments

Emailed you, Brian, the debug file content, which is clear of all exceptions: <?xml version="1.0" encoding="utf-8"?><RedFlagResults xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:...

0 votes

Removed 5.2.8.2 and installed 5.2.6.1 from the link in Brian's post. SAME RESULT. Version confirmed to be 5.2.6.1 Assistance requested... / comments

Removed 5.2.8.2 and installed 5.2.6.1 from the link in Brian's post. SAME RESULT. Version confirmed to be 5.2.6.1 Assistance requested...

0 votes

How can we help you today?

PDinCA

Comments