Failed To Get Schema Name

I am getting a "Failed To Get Schema Name" error when I attempt to add a
view to a database on a remote server. I can add a View to a db on my
localhost server without any problems.

I am working with a report using SQL Reporting Services 2005 in VS.Net 2005

If I open the DB in SQL Management Studio, I can add a view without any
problems. What would be causing this error and how can I fix?

TIA
Dean

How are you creating this view? What are the steps? You said you can create the view using Management Studio - what tool are you using when you can create the view?

You said you are working with a report...so is the error being generated from the report? What does the report do? Do other reports work correctly?

-Sue

|||

i think the problem is with your .net connectivity. What do u mean by Add a view.... is it that u can create view. please post the exact error with error desc and no.

Madhu

|||

In Visual Studio 2005, using Server Explorer, connect to sql server, select db, right click on View node in tree, select Add.

It does not appear to be a Report problem. I'm trying to create a view that can be reused in multiple reports

Dean

|||

Adding a View, means using the Server Explorer window to connect to a database, select the View node and click Add.

"Failed to get schema name" is what shows up in the message box. There is no error number listed

Fail to remotely connect to SQL 2005 named instance

I have 2 instances on a remote machine:
- SQL Server 2000 - default instance
- SQL Server 2005 Standard - named instance called: SQL2005.
I am able to connect to SQL2005 from within the remote machine itself
(loopback). I am also able to connect to the SQL 2000 engine remotely
(remember - it is in default instance).
I am NOT able to connect to SQL2005 engine remotely. I enter server name:
remote\SQL2005, user name: sa, password: xxx, but I get "SQL Server does not
exist or access denied". Trying from various clients: Management Studio, UDL
file, connection string, etc.
I marked "Local and remote connections" in Surface Area Configuration;
TCP/IP is enabled and I have no problem of port definitions (all standard -
1433).
I have no firewall or other limitation accessing that remote machine at all.
I checked all Microsoft docs about SQL connectivity issues - that didn't
help.
I'd appreciate any help...
OferStart the SQL Browser service or connect to the named instance via the IP
address and port number.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Ofer Zelig" <ofer@.newsgroups.nospam> wrote in message
news:%23GhXSTBVGHA.5852@.TK2MSFTNGP10.phx.gbl...
>I have 2 instances on a remote machine:
> - SQL Server 2000 - default instance
> - SQL Server 2005 Standard - named instance called: SQL2005.
> I am able to connect to SQL2005 from within the remote machine itself
> (loopback). I am also able to connect to the SQL 2000 engine remotely
> (remember - it is in default instance).
> I am NOT able to connect to SQL2005 engine remotely. I enter server name:
> remote\SQL2005, user name: sa, password: xxx, but I get "SQL Server does
> not
> exist or access denied". Trying from various clients: Management Studio,
> UDL
> file, connection string, etc.
> I marked "Local and remote connections" in Surface Area Configuration;
> TCP/IP is enabled and I have no problem of port definitions (all
> standard -
> 1433).
> I have no firewall or other limitation accessing that remote machine at
> all.
> I checked all Microsoft docs about SQL connectivity issues - that didn't
> help.
> I'd appreciate any help...
> Ofer
>|||SQL Browser doesn't work.
About the IP number - which IP should I use? As far as I know, it is the
same 1433 port as in SQL 2000.
What should be the full server name if the machine is called "remote" and
the SQL 2005 instance is called "SQL2005" ? Isn't it: remote\SQL2005 ?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23cP4edCVGHA.5828@.TK2MSFTNGP10.phx.gbl...
> Start the SQL Browser service or connect to the named instance via the IP
> address and port number.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Ofer Zelig" <ofer@.newsgroups.nospam> wrote in message
> news:%23GhXSTBVGHA.5852@.TK2MSFTNGP10.phx.gbl...
name:[vbcol=seagreen]
>|||Hello Ofer,
May I suggest that we focus on the theard in setup newsgroup? This might be
easier for community to track this issue. Thanks.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Ofer Zelig" <ofer@.newsgroups.nospam>
>References: <#GhXSTBVGHA.5852@.TK2MSFTNGP10.phx.gbl>
<#cP4edCVGHA.5828@.TK2MSFTNGP10.phx.gbl>
>Subject: Re: Fail to remotely connect to SQL 2005 named instance
>Date: Sun, 2 Apr 2006 15:13:30 +0200
>Lines: 53
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OLnTq8kVGHA.6084@.TK2MSFTNGP14.phx.gbl>
>Newsgroups:
microsoft.public.sqlserver.setup,microsoft.public.sqlserver.connect
>NNTP-Posting-Host: line134-75.adsl.actcom.co.il 192.115.134.75
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.connect:47287
microsoft.public.sqlserver.setup:76030
>X-Tomcat-NG: microsoft.public.sqlserver.connect
>SQL Browser doesn't work.
>About the IP number - which IP should I use? As far as I know, it is the
>same 1433 port as in SQL 2000.
>What should be the full server name if the machine is called "remote" and
>the SQL 2005 instance is called "SQL2005" ? Isn't it: remote\SQL2005 ?
>
>"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
>news:%23cP4edCVGHA.5828@.TK2MSFTNGP10.phx.gbl...
>name:
does[vbcol=seagreen]
Studio,[vbcol=seagreen]
didn't[vbcol=seagreen]
>
>

Fail to remotely connect to SQL 2005 named instance

I have 2 instances on a remote machine:
- SQL Server 2000 - default instance
- SQL Server 2005 Standard - named instance called: SQL2005.
I am able to connect to SQL2005 from within the remote machine itself
(loopback). I am also able to connect to the SQL 2000 engine remotely
(remember - it is in default instance).
I am NOT able to connect to SQL2005 engine remotely. I enter server name:
remote\SQL2005, user name: sa, password: xxx, but I get "SQL Server does not
exist or access denied". Trying from various clients: Management Studio, UDL
file, connection string, etc.
I marked "Local and remote connections" in Surface Area Configuration;
TCP/IP is enabled and I have no problem of port definitions (all standard -
1433).
I have no firewall or other limitation accessing that remote machine at all.
I checked all Microsoft docs about SQL connectivity issues - that didn't
help.
I'd appreciate any help...
Ofer
Start the SQL Browser service or connect to the named instance via the IP
address and port number.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Ofer Zelig" <ofer@.newsgroups.nospam> wrote in message
news:%23GhXSTBVGHA.5852@.TK2MSFTNGP10.phx.gbl...
>I have 2 instances on a remote machine:
> - SQL Server 2000 - default instance
> - SQL Server 2005 Standard - named instance called: SQL2005.
> I am able to connect to SQL2005 from within the remote machine itself
> (loopback). I am also able to connect to the SQL 2000 engine remotely
> (remember - it is in default instance).
> I am NOT able to connect to SQL2005 engine remotely. I enter server name:
> remote\SQL2005, user name: sa, password: xxx, but I get "SQL Server does
> not
> exist or access denied". Trying from various clients: Management Studio,
> UDL
> file, connection string, etc.
> I marked "Local and remote connections" in Surface Area Configuration;
> TCP/IP is enabled and I have no problem of port definitions (all
> standard -
> 1433).
> I have no firewall or other limitation accessing that remote machine at
> all.
> I checked all Microsoft docs about SQL connectivity issues - that didn't
> help.
> I'd appreciate any help...
> Ofer
>
|||SQL Browser doesn't work.
About the IP number - which IP should I use? As far as I know, it is the
same 1433 port as in SQL 2000.
What should be the full server name if the machine is called "remote" and
the SQL 2005 instance is called "SQL2005" ? Isn't it: remote\SQL2005 ?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23cP4edCVGHA.5828@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Start the SQL Browser service or connect to the named instance via the IP
> address and port number.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Ofer Zelig" <ofer@.newsgroups.nospam> wrote in message
> news:%23GhXSTBVGHA.5852@.TK2MSFTNGP10.phx.gbl...
name:
>
|||Hello Ofer,
May I suggest that we focus on the theard in setup newsgroup? This might be
easier for community to track this issue. Thanks.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Ofer Zelig" <ofer@.newsgroups.nospam>
>References: <#GhXSTBVGHA.5852@.TK2MSFTNGP10.phx.gbl>
<#cP4edCVGHA.5828@.TK2MSFTNGP10.phx.gbl>
>Subject: Re: Fail to remotely connect to SQL 2005 named instance
>Date: Sun, 2 Apr 2006 15:13:30 +0200
>Lines: 53
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OLnTq8kVGHA.6084@.TK2MSFTNGP14.phx.gbl>
>Newsgroups:
microsoft.public.sqlserver.setup,microsoft.public. sqlserver.connect
>NNTP-Posting-Host: line134-75.adsl.actcom.co.il 192.115.134.75
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP14.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.connect:47287
microsoft.public.sqlserver.setup:76030[vbcol=seagreen]
>X-Tomcat-NG: microsoft.public.sqlserver.connect
>SQL Browser doesn't work.
>About the IP number - which IP should I use? As far as I know, it is the
>same 1433 port as in SQL 2000.
>What should be the full server name if the machine is called "remote" and
>the SQL 2005 instance is called "SQL2005" ? Isn't it: remote\SQL2005 ?
>
>"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
>news:%23cP4edCVGHA.5828@.TK2MSFTNGP10.phx.gbl...
>name:
does[vbcol=seagreen]
Studio,[vbcol=seagreen]
didn't
>
>