.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

SQL Server Synonyms - unable to view from SPSS

Posted By:      Posted Date: October 06, 2010    Points: 0   Category :Sql Server

Hi All,

I have a client who is connected to a database which has synonyms referencing tables in a different database on the same server. The client used SPSS wizard to see the table & views. Anyway, SPSS wizard shows buttons called tables, views, & synonyms and when client checks either the table or views buttons, they can see the tables and views. But when they click on the synonyms button, no synonyms show up even though they are in the database.

Please help.



View Complete Post

More Related Resource Links

Unable to view SharePoint nodes in Server Explorer


Using Visual Studio 2010, I right-click on SharePoint Connections in Server Explorer and select "Add Connection..."  My SharePoint 2010 site is on the same machine, so I enter http://localhost.  (I've also tried the actual machine name, http://sp2010dev.)  The connection is created with the root site at the top and all the nodes underneath (ContentTypes, Features, etc.).  Some of the nodes I can expand (e.g. List Templates expands to show different List Template types; Lists and Libraries expands to show Document Libraries and Lists).  But then when I try to expand further, I get an error message that states the following:

Unable to retrieve information for this node, possibly because the node has been deleted or its connection disrupted.  If the item exists in SharePoint, be sure it is accessible

I have not found any information about this error, and I've exhausted all attempts to permissions above what I've already created.


need help about "Unable to connect to remote server." using HttpWebRequest


Hello friends 
I am creating an application where I want to store an html page from one of my websites into another web site. 
For the same purpose I am taking the url of the html pages 
for example if I want to copy this page "http://mydomain.com/html/page1.html" then i take this url from a text box which user enters.

Need to install Report View Redistributables on the report server?

Hi there:   I've developed a webapps utilizing MS reporting service reports and it works fine on my local machine. When I promoted to production server, it failed . People say I need to install MS reportViewer redistributables on the report server.   1. What is this MS ReportView redistributables anyway??? I've already included ReportView control in my apps and can someone explain to me why I need to install on the report server?   2. If I can not install the redistributables on the report server as the client may refuse to install due to whatsoever reasons, it there anyway to get around?   3. For any winForms apps, do I need to install the redistributables on the report server?   thanks    Hui--Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

How to create a view in my database from a table in another server/database

Is there a way to create a view in my database referencing a table in another server/database if I have the connection information.  I know how to do it in Oracle, simply create a database link, but have never done so in sqlserver.

Unable to Connect to server

I have install sql server 2008 on window 7. But connection to server is failed. These are the options. Sever Type Server Name. Authentication. Login. Pasword. anybody have answer my question????

Unable to open physical file - Operating system error 5: 5(error not found) Microsoft SQL Server: Er

I am trying to attach a database to SQL 2005. This database has not previously been attached. I have only just installed SQL.   I get the following message: Unable to open physical file "C:\ArrowSQL\Arr@Data\Arrow_data.mdf" Operating system error 5: "5(error not found)" (Microsoft SQL Server: Error 5120)".   I have loaded SQL and the database fiel and directory with the same user acccount which is a local adminstrator ont hsi machine. I have checked that I have read/write access to the file.   The machine runs Windows Vista Business. SQL has SP 2 loaded.   What causes this?

unable to create new table in sql server 2000 enterprise manager on windows7(Operating system)

i have successfuly installed sql server 2000 on windows7 and i am able to browse all the tables and edit aswell(on enterprise manager) but i have a problem while creating new tables it says ' MMC has detected an error in a snap-in' and provides options to either continue with the error or send a report to microsoft ,   Please help regarding this compatibility issue   Thanks in advance !

20,000 foot view: Sql Server clustering vs. Windows OS Clustering

I read that Sql Server Failover requires Windows Sevrer clustering to be in place first. (The former builds on the latter). Why is this the case? In other words, what does "sql server clustering" bring to the mix  that normal Windows clustering doesn't supply? TIA, Barkingdog  

Unable to install SQL Server 2008 Express R2 after installing .NET 4.0

Hi experts, I intend to redistribute SQL Server 2008 Express R2 in my installer. I've extracted the setup files from SQLEXPR32_x86.exe and pass in the appropriate command line parameters during the setup. Recently, I noticed if I applied the following Windows Update: .NET 4.0 Client Profile, I will hit into the following error when I installed SQL express. .NET Runtime 4.0 Error Reporting EventType clr20r3, P1 setup100.exe, P2 10.50.1600.1, P3 4bb67524, P4 mscorlib, P5, P6 4ba1da6f, P7 44f0, P8 32, P9 system.security.security, P10 NIL. .NET Runtime Application: setup100.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.Security.SecurityException Stack: at Microsoft.SqlServer.Chainer.Setup.Setup.DebugBreak() at Microsoft.SqlServer.Chainer.Setup.Setup.Main() Running the setup.exe from a file server will give these errors but if I copied the entire setup files to a local folder and run setup.exe from there, it runs fine. May I know what am I missing? I definitely need to support to install SQL express running from a file server location. Thanks, MK  

Unable to connect to the ASP.NET Development Server

 I have VS 2008 with SP1 installed on Win XP. I have .NET 3.5 with SP1 installed When I ran and opened an existing project for the first time, I got the below error WebDev.WebServer.exe has encountered a problem and needs to close. After this error, I continusly get  "Unable to connect to the ASP.NET Development Server." whenever I run the website. I checked the internet and ASP.NET forum and tried all the following Making port numbers auto assign Making it to a specific port number using the Custom web server Tried creating new web site and checking Replaced WebDev.WebServer.EXE after downloading it from a website My anti virus have not blocked any websites as such I tried resetting VS settings by running devenv /resetsettings Can any one help me, what else might be the problem? Thanks in advance

Unable to connect to SQL Server 2005 remotly, all client protocols are blank

I have an installation of SQL 2005 and had issues connecting remotly. Looking at the client protocolols, they are all blank. I can see that TCPIP, Named Pipes, VIA, etc. are 'enabled', but where the words 'TCPIP', 'Names Pipes', etc. should be, it's just blank. I tried to install SQL 2008R hoping the Client Protocols would be corrected during the installaion, but they were not. I'm assuming the issue with the Client Protocols not showing up is a symptom of the problem. Does anyone have any ideas? Thanks!

Reporting Services Add-In for MOSS2007 : Unable to connect to the database Error at "Set Server Defa

Dear Expert, I've succesfully install the Add-In + configure the reporting services (integrated mode) + activate the features on my MOSS2007. As we know by activating this at my Central Admin, i'm able to see "Reporting Services" under my Application Management as below:   1) Manage Integration Setting   ---> My report url : http://servername:808/ReportServer (Trusted Account) 2) Grand Database Access --->  My setting : <servername> with default instance  3) Set Server Defaults ---> Area that i receive an error "Unable to connect to database" Anybody here have a same experience? please assist me, Thanks in Advanced My Note: OS : Windows Server 2008 Enterprise x64bit (SP2) SQL : SQL 2005 with latest Service Pack (SP3)  My Error Log: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>   <Locale>en-US</Locale>   <TimeZone>Malay Peninsula Standard Time</TimeZone>   <Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__08_04_2010_10_51_59.log</Path>   <SystemName>SEINE</SystemName>   <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>   <OSVersion>6.0.6002.131072</OS

Unable to create Web Folders in Windows Server 2008 R2

Hi, We are unable to create web folder from a Windows Server 2008 R2 system as we do in Windows XP. The web url cannot be identified. The web url is an oracle repository application built in 32-bit OS and now we need this to be added in Windows Server 2008 R2 machine. Kindly help.  

Unable to load workflow actions from the server - problem!

Hi, I have problem on Sharepoint 2010 RTM (new installation). I use workflows from the begining and I had no problem since yesterday. I tried to make custom workflow and the SP designer has frozen when saving it. Since than I get message "unable to load workflow actions from server. Please contact your server administrator." every time I want to customize or make new workflow. Need fast solution, Please help. Regards, Luka

Crystal Reprort:unable to connect with sql server

Hi Guys,               i have a Problem in crystal report which is unable to connect with the hierarchy...can any one give me the solution..i have done this with .xsd nd My code is as Under...Imports SystemImports System.Data.SqlClientImports CrystalDecisions.SharedImports CrystalDecisions.CrystalReports.EngineImports CrystalDecisionsImports CrystalDecisions.ReportSourcePartial Class Default2    Inherits System.Web.UI.Page    'Dim cn As New ConnectionInfo    Dim crtableLogoninfos As New TableLogOnInfos()    Dim crtableLogoninfo As New TableLogOnInfo()    Dim crConnectionInfo As New ConnectionInfo()    Dim CrTables As Tables    Dim CrTable As Table    'Dim TableCounter    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load        Dim crReportDocument As New ReportDocument()        crReportDocument.Load("C:\Users\Utpal\Documents\Visual Studio 2008\WebSites\Report 2\CrystalReport.rpt")        With crConnectionInfo            .ServerName = "\SQLEXPRESS"&nb

Unable to See List of Marked Transactions on New Server

I am trying to do a TFS test restore to new server following the TFS 2010 Backup and Restore processes below verbatim (SQL 2008 SP1): Backup TFS http://msdn.microsoft.com/en-us/library/ms253070.aspx Restore to Different Server http://msdn.microsoft.com/en-us/library/ms252516.aspx#RestoreDB Restore Single Server Deployment to New Hardware http://msdn.microsoft.com/en-us/library/ff459215.aspx I can restore the database to the restoring state on a new server; however, when applying the transaction log backup I don't see any marked transactions to restore to.  I don't even get a list to choose from.  I can restore the database to the original server successfully and can see list of marked transactions to restore to. Is there anything that we could keep me from seeing the list of marked transactions on the new server?  Does this have anything to do with the fact that the marks are stored in the msdb.dbo.logmarkhistory database? Thanks in Advance, Michael

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Object canno

hello,i am using a web servicewrtitten in .net and i access the webservice from my wepApplication i get this error System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Object cannot be cast from DBNull to other types.my code is access webservice: protected void btnSave_Click(object sender, EventArgs e)        {            int intStatusCode;            dtProjectStatus = (DataTable)ViewState["dtProjectStatus"];            try            {                objService.Credentials = System.Net.CredentialCache.DefaultCredentials;                if(dtProjectStatus.Rows.Count>0)                {                  intStatusCode = objService.InsertTest(dtProjectStatus);                }   
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend