Thursday, March 29, 2012
Can't connect after Windows XP SP2
over a network.
I installed SP3a for MSDE 2000 but the problem persists.
I put a permission to sqlserver.exe but my access to it over a network (and
internet) is blocked.
How can i solve this problem?
thanks,
Goncalo Boleo
hi,
"john raub" <john_raub@.ascendrms.com> ha scritto nel messaggio
news:20c601c4bdd8$f28b0840$a601280a@.phx.gbl
> problem with a customer that installed a 3rd party
> firewall software. He has since uninstalled, but we still
> can't connect to the machine containing the MSDE server.
please have a look at
http://support.microsoft.com/default.aspx?scid=kb;[LN];841251
http://support.microsoft.com/default.aspx?kbid=841249
http://support.microsoft.com/default.aspx?scid=kb;[LN];884012
to see if they can help
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
can't connect 2005 reporting server...need help
window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
admin and got error when i try to connect report server:
Cannot execute a program. The command being executed was
"C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
@."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
execute a program. The command being executed was
"C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
@."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
anyone knows about this and thanks alot for a help
Karen,On Apr 27, 1:50 pm, Karen Chen <KarenC...@.discussions.microsoft.com>
wrote:
> We installed sql 2005 server and reporting services (standard edition) on
> window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
> admin and got error when i try to connect report server:
> Cannot execute a program. The command being executed was
> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information about
> the error and where it originated in the code.
> Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
> execute a program. The command being executed was
> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> Source Error:
> An unhandled exception was generated during the execution of the current web
> request. Information regarding the origin and location of the exception can
> be identified using the exception stack trace below.
> anyone knows about this and thanks alot for a help
> Karen,
I received your email and noticed that you posted here as well. If you
do not have the .NET 2.0 framework installed, this might be the
problem.
Regards,
Enrique Martinez
Sr. Software Consultant
Can't connect 2005 reporting server
window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
admin and got error when i try to connect report server:
Cannot execute a program. The command being executed was
"C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
@."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
execute a program. The command being executed was
"C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
@."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
anyone knows about this and thanks alot for a help
Karen,On Apr 27, 2:24 pm, Karen Chen <KarenC...@.discussions.microsoft.com>
wrote:
> We installed sql 2005 server and reporting services (standard edition) on
> window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
> admin and got error when i try to connect report server:
> Cannot execute a program. The command being executed was
> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information about
> the error and where it originated in the code.
> Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
> execute a program. The command being executed was
> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> Source Error:
> An unhandled exception was generated during the execution of the current web
> request. Information regarding the origin and location of the exception can
> be identified using the exception stack trace below.
> anyone knows about this and thanks alot for a help
> Karen,
Please refer to my previous post at:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9efeaacdc0875e6d/7ce06f2ec8a78f36#7ce06f2ec8a78f36
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Enrique,
Thanks your replay and i do have .NET 2.0 installed. I feel like its
security issue.
What is security context of .NETservice account (NT
Authority\NetworkService)? and how do you confiure this account for web
service identity?
"EMartinez" wrote:
> On Apr 27, 2:24 pm, Karen Chen <KarenC...@.discussions.microsoft.com>
> wrote:
> > We installed sql 2005 server and reporting services (standard edition) on
> > window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
> > admin and got error when i try to connect report server:
> > Cannot execute a program. The command being executed was
> > "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> > @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> > Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> > Description: An unhandled exception occurred during the execution of the
> > current web request. Please review the stack trace for more information about
> > the error and where it originated in the code.
> >
> > Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
> > execute a program. The command being executed was
> > "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> > @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> > Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> >
> > Source Error:
> > An unhandled exception was generated during the execution of the current web
> > request. Information regarding the origin and location of the exception can
> > be identified using the exception stack trace below.
> >
> > anyone knows about this and thanks alot for a help
> >
> > Karen,
>
> Please refer to my previous post at:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9efeaacdc0875e6d/7ce06f2ec8a78f36#7ce06f2ec8a78f36
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Hi Enrique,
Thanks your replay and we do have .Net 2.0 installed. I feel like that this
problem related to security issue.
How do you configure your web service account (NT Authoriry/NetworkServices)
?
Karen,
"EMartinez" wrote:
> On Apr 27, 2:24 pm, Karen Chen <KarenC...@.discussions.microsoft.com>
> wrote:
> > We installed sql 2005 server and reporting services (standard edition) on
> > window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
> > admin and got error when i try to connect report server:
> > Cannot execute a program. The command being executed was
> > "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> > @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> > Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> > Description: An unhandled exception occurred during the execution of the
> > current web request. Please review the stack trace for more information about
> > the error and where it originated in the code.
> >
> > Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
> > execute a program. The command being executed was
> > "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> > @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> > Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> >
> > Source Error:
> > An unhandled exception was generated during the execution of the current web
> > request. Information regarding the origin and location of the exception can
> > be identified using the exception stack trace below.
> >
> > anyone knows about this and thanks alot for a help
> >
> > Karen,
>
> Please refer to my previous post at:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9efeaacdc0875e6d/7ce06f2ec8a78f36#7ce06f2ec8a78f36
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Can't Connect
When I go into the sql server management studio, there is only
one entry under the "database engine" entry in the registered servers'
panel on the left. It is MyServerName\SQLEXPRESS.
When I click on it and then select connect, either new query
or object explorer, I get one of the following errors.
An error has occurred while establishing a connection to there server.
When connecting to SQL Server 2005, the failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (Provider : Sql Network interfaces, error: 26 - Error locating
Server/Instance Specified )
An error has occurred while establishing a connection to there server.
When connecting to SQL Server 2005, the failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (Provider : Named Pipes Provider, error 40 - Could not open
a connection
to sql server.
I have looked all over the internet, but couldn't find anything that
would help.
I went into the sql server configuration manger, and enabled the name
pipes and rebooted.
I didn't work. In the sql service configuration manager I have five
services that are status of
running and startup mode of automatic. However they are not for the
SQLExpress server.
They are for another sql server name, that I put in for the server name
when I installed
sql server 2005. I thought that would be the server name.
There are two entries under sql server 2005 network configuration
Protocals for SQLEXPRESS and
Protocals for Myotherservername
How can I connect.
Why do I have two instances are those instances of servers,
I thought that there was only server.
What do I do?
Thanks in Advance,
Laurence
I suggest starting with my blog entry on connecting. Just search
www.betav.com/blog/billva. There are several relevant articles there.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Larry" <NoSpam@.Something.com> wrote in message
news:e5O9nLU3HHA.5316@.TK2MSFTNGP04.phx.gbl...
>I have just installed Sql server 2005 on my Win XP Pro machine.
> When I go into the sql server management studio, there is only
> one entry under the "database engine" entry in the registered servers'
> panel on the left. It is MyServerName\SQLEXPRESS.
> When I click on it and then select connect, either new query
> or object explorer, I get one of the following errors.
> An error has occurred while establishing a connection to there server.
> When connecting to SQL Server 2005, the failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (Provider : Sql Network interfaces, error: 26 - Error
> locating
> Server/Instance Specified )
> An error has occurred while establishing a connection to there server.
> When connecting to SQL Server 2005, the failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (Provider : Named Pipes Provider, error 40 - Could not open a
> connection
> to sql server.
> I have looked all over the internet, but couldn't find anything that would
> help.
> I went into the sql server configuration manger, and enabled the name
> pipes and rebooted.
> I didn't work. In the sql service configuration manager I have five
> services that are status of
> running and startup mode of automatic. However they are not for the
> SQLExpress server.
> They are for another sql server name, that I put in for the server name
> when I installed
> sql server 2005. I thought that would be the server name.
> There are two entries under sql server 2005 network configuration
> Protocals for SQLEXPRESS and
> Protocals for Myotherservername
>
> How can I connect.
> Why do I have two instances are those instances of servers,
> I thought that there was only server.
> What do I do?
> Thanks in Advance,
> Laurence
>
>
>
>
|||Thank You.
William Vaughn wrote:
> I suggest starting with my blog entry on connecting. Just search
> www.betav.com/blog/billva. There are several relevant articles there.
>
sql
Can't connect
machine. I've currently problems to connect to the SQL-Server getting the
following error message
C:\Dokumente und Einstellungen\Robert>sqlcmd
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while
establi
shing a connection to the server. When connecting to SQL Server 2005, this
failu
re may be caused by the fact that under the default settings SQL Server does
not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
I've allready
- enabled the Protocolls via the SQL Server Configuration Manager
- stopped the firewall
- tried it via Access, VS 2005 Server Explorer, ...
I get access to the database when I use SSEUTIL ! Using this tool it was
e.g. possible to attach/dettach a database.
Any idea whats wrong?
Are you in fact trying to connect remotely? If you are, you will need to
enable and start SQLBrowser also. If not, are you using .\sqlexpress as
your server name in the connection string?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Robert" <Robert@.discussions.microsoft.com> wrote in message
news:B34E3E09-A80B-43C8-B164-4D4B299C10BF@.microsoft.com...
> I've installed Visual Studio 2005 (including SQL Express) on a XP Home
> machine. I've currently problems to connect to the SQL-Server getting the
> following error message
> C:\Dokumente und Einstellungen\Robert>sqlcmd
> HResult 0x2, Level 16, State 1
> Named Pipes Provider: Could not open a connection to SQL Server [2].
> Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while
> establi
> shing a connection to the server. When connecting to SQL Server 2005, this
> failu
> re may be caused by the fact that under the default settings SQL Server
> does
> not
> allow remote connections..
> Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
> I've allready
> - enabled the Protocolls via the SQL Server Configuration Manager
> - stopped the firewall
> - tried it via Access, VS 2005 Server Explorer, ...
> I get access to the database when I use SSEUTIL ! Using this tool it was
> e.g. possible to attach/dettach a database.
> Any idea whats wrong?
|||Hi Roger,
thank you very much. I missed the ".\sqlexpress". Adding this to the
connection string everything worked.
"Roger Wolter[MSFT]" wrote:
> Are you in fact trying to connect remotely? If you are, you will need to
> enable and start SQLBrowser also. If not, are you using .\sqlexpress as
> your server name in the connection string?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Robert" <Robert@.discussions.microsoft.com> wrote in message
> news:B34E3E09-A80B-43C8-B164-4D4B299C10BF@.microsoft.com...
>
>
Can't Connect
When I go into the sql server management studio, there is only
one entry under the "database engine" entry in the registered servers'
panel on the left. It is MyServerName\SQLEXPRESS.
When I click on it and then select connect, either new query
or object explorer, I get one of the following errors.
An error has occurred while establishing a connection to there server.
When connecting to SQL Server 2005, the failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (Provider : Sql Network interfaces, error: 26 - Error locating
Server/Instance Specified )
An error has occurred while establishing a connection to there server.
When connecting to SQL Server 2005, the failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (Provider : Named Pipes Provider, error 40 - Could not open
a connection
to sql server.
I have looked all over the internet, but couldn't find anything that
would help.
I went into the sql server configuration manger, and enabled the name
pipes and rebooted.
I didn't work. In the sql service configuration manager I have five
services that are status of
running and startup mode of automatic. However they are not for the
SQLExpress server.
They are for another sql server name, that I put in for the server name
when I installed
sql server 2005. I thought that would be the server name.
There are two entries under sql server 2005 network configuration
Protocals for SQLEXPRESS and
Protocals for Myotherservername
How can I connect.
Why do I have two instances are those instances of servers,
I thought that there was only server.
What do I do?
Thanks in Advance,
LaurenceI suggest starting with my blog entry on connecting. Just search
www.betav.com/blog/billva. There are several relevant articles there.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Larry" <NoSpam@.Something.com> wrote in message
news:e5O9nLU3HHA.5316@.TK2MSFTNGP04.phx.gbl...
>I have just installed Sql server 2005 on my Win XP Pro machine.
> When I go into the sql server management studio, there is only
> one entry under the "database engine" entry in the registered servers'
> panel on the left. It is MyServerName\SQLEXPRESS.
> When I click on it and then select connect, either new query
> or object explorer, I get one of the following errors.
> An error has occurred while establishing a connection to there server.
> When connecting to SQL Server 2005, the failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (Provider : Sql Network interfaces, error: 26 - Error
> locating
> Server/Instance Specified )
> An error has occurred while establishing a connection to there server.
> When connecting to SQL Server 2005, the failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (Provider : Named Pipes Provider, error 40 - Could not open a
> connection
> to sql server.
> I have looked all over the internet, but couldn't find anything that would
> help.
> I went into the sql server configuration manger, and enabled the name
> pipes and rebooted.
> I didn't work. In the sql service configuration manager I have five
> services that are status of
> running and startup mode of automatic. However they are not for the
> SQLExpress server.
> They are for another sql server name, that I put in for the server name
> when I installed
> sql server 2005. I thought that would be the server name.
> There are two entries under sql server 2005 network configuration
> Protocals for SQLEXPRESS and
> Protocals for Myotherservername
>
> How can I connect.
> Why do I have two instances are those instances of servers,
> I thought that there was only server.
> What do I do?
> Thanks in Advance,
> Laurence
>
>
>
>|||Thank You.
William Vaughn wrote:
> I suggest starting with my blog entry on connecting. Just search
> www.betav.com/blog/billva. There are several relevant articles there.
>
Can't connect
machine. I've currently problems to connect to the SQL-Server getting the
following error message
C:\Dokumente und Einstellungen\Robert>sqlcmd
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while
establi
shing a connection to the server. When connecting to SQL Server 2005, this
failu
re may be caused by the fact that under the default settings SQL Server does
not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
I've allready
- enabled the Protocolls via the SQL Server Configuration Manager
- stopped the firewall
- tried it via Access, VS 2005 Server Explorer, ...
I get access to the database when I use SSEUTIL ! Using this tool it was
e.g. possible to attach/dettach a database.
Any idea whats wrong?Are you in fact trying to connect remotely? If you are, you will need to
enable and start SQLBrowser also. If not, are you using .\sqlexpress as
your server name in the connection string?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Robert" <Robert@.discussions.microsoft.com> wrote in message
news:B34E3E09-A80B-43C8-B164-4D4B299C10BF@.microsoft.com...
> I've installed Visual Studio 2005 (including SQL Express) on a XP Home
> machine. I've currently problems to connect to the SQL-Server getting the
> following error message
> C:\Dokumente und Einstellungen\Robert>sqlcmd
> HResult 0x2, Level 16, State 1
> Named Pipes Provider: Could not open a connection to SQL Server [2].
> Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while
> establi
> shing a connection to the server. When connecting to SQL Server 2005, this
> failu
> re may be caused by the fact that under the default settings SQL Server
> does
> not
> allow remote connections..
> Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
> I've allready
> - enabled the Protocolls via the SQL Server Configuration Manager
> - stopped the firewall
> - tried it via Access, VS 2005 Server Explorer, ...
> I get access to the database when I use SSEUTIL ! Using this tool it was
> e.g. possible to attach/dettach a database.
> Any idea whats wrong?|||Hi Roger,
thank you very much. I missed the ".\sqlexpress". Adding this to the
connection string everything worked.
"Roger Wolter[MSFT]" wrote:
> Are you in fact trying to connect remotely? If you are, you will need to
> enable and start SQLBrowser also. If not, are you using .\sqlexpress as
> your server name in the connection string?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Robert" <Robert@.discussions.microsoft.com> wrote in message
> news:B34E3E09-A80B-43C8-B164-4D4B299C10BF@.microsoft.com...
>
>
Cant Connect
Server Management Studio and try and connect but I get the error;
...this failure may be caused buy the face that under the default settings
SQL server does not allow remote connections (provider: TCP Provider, error:
0 - No connection could be made because the target machine actively refused
it) (Microsoft SQL Server, error 10061)
Now this error only happens when connecting to the DB engine, it works fine
connecting to analysis services. I have chosen Windows Auth and also
specifying my sql account with the password with is a member of the SQL
groups in the users container but still doesn't work. I am logged in as
Administrator but I get this error.
I have installed SQL before and it worked fine, then it messed up so I
installed SQLExpress now I installed 2005 beta again to play some more and
its done this.
I am using server 2003 SP1
Thanks for your help
ChrisFIXED :D
I just needed to manually create the MSSQL ODBC connector and its fine
learn something new everyday
"kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
news:ytiQf.138242$DM.34380@.fe3.news.blueyonder.co.uk...
>I have installed SQL 2005 and just done a normal install. I have opened
>Server Management Studio and try and connect but I get the error;
> ...this failure may be caused buy the face that under the default settings
> SQL server does not allow remote connections (provider: TCP Provider,
> error: 0 - No connection could be made because the target machine actively
> refused it) (Microsoft SQL Server, error 10061)
> Now this error only happens when connecting to the DB engine, it works
> fine connecting to analysis services. I have chosen Windows Auth and also
> specifying my sql account with the password with is a member of the SQL
> groups in the users container but still doesn't work. I am logged in as
> Administrator but I get this error.
> I have installed SQL before and it worked fine, then it messed up so I
> installed SQLExpress now I installed 2005 beta again to play some more and
> its done this.
> I am using server 2003 SP1
> Thanks for your help
> Chris
>|||Going on from this however, if i wanted a desktop machine to connect, say,
Microsoft Access to my SQL database, do i need to create a MSSQL client
connection in the desktop ODBC?
Thanks
Chris
"kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
news:zsjQf.138255$DM.65219@.fe3.news.blueyonder.co.uk...
> FIXED :D
> I just needed to manually create the MSSQL ODBC connector and its fine
> learn something new everyday
> "kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
> news:ytiQf.138242$DM.34380@.fe3.news.blueyonder.co.uk...
>|||> Going on from this however, if i wanted a desktop machine to connect,
> say, Microsoft Access to my SQL database, do i need to create a MSSQL
> client connection in the desktop ODBC?
This is one of two possible choices.
The other one is to create an ADP and use OLE DB provider.
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution|||sorry to sound dumb, but could you dumb that down a bit please lol
thanks
chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bbff8c8132b72f2d7d6@.news.virgilio.it...
> This is one of two possible choices.
> The other one is to create an ADP and use OLE DB provider.
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>|||> sorry to sound dumb, but could you dumb that down a bit please lol
Sorry for my poor english, but I was not able to welle translate your senten
ce.
May you explain better, please?
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution|||Can you explain what you mean by
"The other one is to create an ADP and use OLE DB provider."
I dont know what it is, also, would it be better to do it your way or my
way?
Thanks
Chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bc088c813301ae47a36@.news.virgilio.it...
> Sorry for my poor english, but I was not able to welle translate your
> sentence. May you explain better, please?
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>|||> 2) ODBC driver
> 2) this method lets you use Access as simply as with any other MDB.
> Indeed, you have to define a system DSN in Windows Data Source, then
> you create an MDB and link tables from the ODBC source you defined.
> Yet, you are not able to exploit stored procedures, views, functions,
> and so on.
I forgot to say that using ODBC driver you cannot see relationships too.
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution|||Ah yes I do remember now, I think I have tried to use these befor.
Thanks for your assistance
Chris
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:hr2612lvbhhr1teiojvhb7aba44nb3huoe@.
4ax.com...
> ADP is an Access Data Project - an Access front end that
> uses SQL Server as the backend and doesn't involve Jet or
> mdb files. You can find more information on this in the
> Access help files - look for Access Project topics.
> -Sue
> On Sat, 11 Mar 2006 15:16:14 GMT, "kicken18"
> <chrisflyer@.blueyonder.co.uk> wrote:
>
>|||Thank you for the good help there, I can now go and test this.
Thank you for your time
Chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bc418c813581ba41986@.news.virgilio.it...
> From Access you have two possibilities to use a MS SQL database.
> 1) OLE DB provider
> 2) ODBC driver
> 1) this is the best choice, in conjuntion to an Access Data Project.
> Microsoft created ADPs in order to interface SQL Server databases by
> Access via OLE DB provider and Jet Data Provider. ADPs connect to a SQL
> instance and let you see tables, stored procedures, views, functions, and
> so on.
> 2) this method lets you use Access as simply as with any other MDB.
> Indeed, you have to define a system DSN in Windows Data Source, then you
> create an MDB and link tables from the ODBC source you defined. Yet, you
> are not able to exploit stored procedures, views, functions, and so on.
> I suggest you to use the first method.
> Bye.
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>sql
Cant Connect
Server Management Studio and try and connect but I get the error;
...this failure may be caused buy the face that under the default settings
SQL server does not allow remote connections (provider: TCP Provider, error:
0 - No connection could be made because the target machine actively refused
it) (Microsoft SQL Server, error 10061)
Now this error only happens when connecting to the DB engine, it works fine
connecting to analysis services. I have chosen Windows Auth and also
specifying my sql account with the password with is a member of the SQL
groups in the users container but still doesn't work. I am logged in as
Administrator but I get this error.
I have installed SQL before and it worked fine, then it messed up so I
installed SQLExpress now I installed 2005 beta again to play some more and
its done this.
I am using server 2003 SP1
Thanks for your help
Chris
FIXED :D
I just needed to manually create the MSSQL ODBC connector and its fine
learn something new everyday
"kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
news:ytiQf.138242$DM.34380@.fe3.news.blueyonder.co. uk...
>I have installed SQL 2005 and just done a normal install. I have opened
>Server Management Studio and try and connect but I get the error;
> ...this failure may be caused buy the face that under the default settings
> SQL server does not allow remote connections (provider: TCP Provider,
> error: 0 - No connection could be made because the target machine actively
> refused it) (Microsoft SQL Server, error 10061)
> Now this error only happens when connecting to the DB engine, it works
> fine connecting to analysis services. I have chosen Windows Auth and also
> specifying my sql account with the password with is a member of the SQL
> groups in the users container but still doesn't work. I am logged in as
> Administrator but I get this error.
> I have installed SQL before and it worked fine, then it messed up so I
> installed SQLExpress now I installed 2005 beta again to play some more and
> its done this.
> I am using server 2003 SP1
> Thanks for your help
> Chris
>
|||Going on from this however, if i wanted a desktop machine to connect, say,
Microsoft Access to my SQL database, do i need to create a MSSQL client
connection in the desktop ODBC?
Thanks
Chris
"kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
news:zsjQf.138255$DM.65219@.fe3.news.blueyonder.co. uk...
> FIXED :D
> I just needed to manually create the MSSQL ODBC connector and its fine
> learn something new everyday
> "kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
> news:ytiQf.138242$DM.34380@.fe3.news.blueyonder.co. uk...
>
|||> Going on from this however, if i wanted a desktop machine to connect,
> say, Microsoft Access to my SQL database, do i need to create a MSSQL
> client connection in the desktop ODBC?
This is one of two possible choices.
The other one is to create an ADP and use OLE DB provider.
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution
|||sorry to sound dumb, but could you dumb that down a bit please lol
thanks
chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bbff8c8132b72f2d7d6@.news.virgilio.it. ..
> This is one of two possible choices.
> The other one is to create an ADP and use OLE DB provider.
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>
|||> sorry to sound dumb, but could you dumb that down a bit please lol
Sorry for my poor english, but I was not able to welle translate your sentence.
May you explain better, please?
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution
|||Can you explain what you mean by
"The other one is to create an ADP and use OLE DB provider."
I dont know what it is, also, would it be better to do it your way or my
way?
Thanks
Chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bc088c813301ae47a36@.news.virgilio.it. ..
> Sorry for my poor english, but I was not able to welle translate your
> sentence. May you explain better, please?
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>
|||ADP is an Access Data Project - an Access front end that
uses SQL Server as the backend and doesn't involve Jet or
mdb files. You can find more information on this in the
Access help files - look for Access Project topics.
-Sue
On Sat, 11 Mar 2006 15:16:14 GMT, "kicken18"
<chrisflyer@.blueyonder.co.uk> wrote:
>Can you explain what you mean by
>"The other one is to create an ADP and use OLE DB provider."
>I dont know what it is, also, would it be better to do it your way or my
>way?
>Thanks
>Chris
>"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
>news:875ea355bc088c813301ae47a36@.news.virgilio.it ...
>
|||Ah yes I do remember now, I think I have tried to use these befor.
Thanks for your assistance
Chris
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:hr2612lvbhhr1teiojvhb7aba44nb3huoe@.4ax.com...
> ADP is an Access Data Project - an Access front end that
> uses SQL Server as the backend and doesn't involve Jet or
> mdb files. You can find more information on this in the
> Access help files - look for Access Project topics.
> -Sue
> On Sat, 11 Mar 2006 15:16:14 GMT, "kicken18"
> <chrisflyer@.blueyonder.co.uk> wrote:
>
|||Thank you for the good help there, I can now go and test this.
Thank you for your time
Chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bc418c813581ba41986@.news.virgilio.it. ..
> From Access you have two possibilities to use a MS SQL database.
> 1) OLE DB provider
> 2) ODBC driver
> 1) this is the best choice, in conjuntion to an Access Data Project.
> Microsoft created ADPs in order to interface SQL Server databases by
> Access via OLE DB provider and Jet Data Provider. ADPs connect to a SQL
> instance and let you see tables, stored procedures, views, functions, and
> so on.
> 2) this method lets you use Access as simply as with any other MDB.
> Indeed, you have to define a system DSN in Windows Data Source, then you
> create an MDB and link tables from the ODBC source you defined. Yet, you
> are not able to exploit stored procedures, views, functions, and so on.
> I suggest you to use the first method.
> Bye.
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>
Can't conenct to sql 2005
Can you connect to SQL 2005 if you're not part of the domain the server is
installed in?
I installed the client and it can see my SQL 2000 server but not the SQL
2005 server.
Is it because the laptop I installed it on is not part of the domain?
If so, beside having it join the domain, is there a way to connect to it?
Thanks!
Simon
Hi,
this is not easy tell. Is SQL Server 2005 installed on the same box as SQL
Server 2000 ? Does it have a default port or any other than the 1433 port ?
If using a dynamic or any other port, do you have SQL Browser started on the
2k5 box ? If you cant start SQL Browser for some reason, did you try to
specify the port number after the server name to make the connection using
Servername,Portnumber as the servername within your connection dialogues ?
Jens K. Suessmeyer.
http://www.sqlserver2005.de
"Simon Renshaw" <simon@.benchmarkconsulting.com> wrote in message
news:OHQCXfoYHHA.4008@.TK2MSFTNGP05.phx.gbl...
> Hi,
> Can you connect to SQL 2005 if you're not part of the domain the server is
> installed in?
> I installed the client and it can see my SQL 2000 server but not the SQL
> 2005 server.
> Is it because the laptop I installed it on is not part of the domain?
> If so, beside having it join the domain, is there a way to connect to it?
> Thanks!
> Simon
>
|||No, 2005 and 2000 are installed on different machines. And I used the
standard ports.
By the client I meant the SQL Server Management Studio. Sorry for the
confusion.
On my station (which is part of the domain), I can access the 2005 server
using SQL Server Management Studio.
On the laptop, I cannot access the 2005 server using SQL Server Management
Studio.
"Jens K. Suessmeyer" <Jens@.NoSpamhere-sqlserver2005.de> wrote in message
news:82730AB1-9842-4B47-A61E-BAED0215B0DE@.microsoft.com...
> Hi,
> this is not easy tell. Is SQL Server 2005 installed on the same box as SQL
> Server 2000 ? Does it have a default port or any other than the 1433 port
> ? If using a dynamic or any other port, do you have SQL Browser started on
> the 2k5 box ? If you cant start SQL Browser for some reason, did you try
> to specify the port number after the server name to make the connection
> using Servername,Portnumber as the servername within your connection
> dialogues ?
> Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Simon Renshaw" <simon@.benchmarkconsulting.com> wrote in message
> news:OHQCXfoYHHA.4008@.TK2MSFTNGP05.phx.gbl...
>
Tuesday, March 27, 2012
Can't Attach to DB File using SSMS
Hi all,
I have "SQL Server Express" as well as SSMS-E installed on the same machine. I am trying to get SSMS-E to connect to a database (i.e., an .MDF file) that resides in a folder on the desktop.
After establishing a connection to my "SQL Server Express" instance within SSMS-E, I right-click on "Databases", in the "Object Explorer" window and select "Attach..." and click the "Add..." button. The resulting dialog box opens in the directory:
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" where I see several MDF files. But as I said, my MDF is not in this directory - it's on the desktop.
If I try to navigate to the proper directory on the desktop I see no MDF files. In fact, I cannot even navigate past my username -- that is, I cannot even navigate to the desktop, let alone folders on the desktop. I don't know why.
Of course I *could* put the MDF file in the SQL-E approved directory but shouldn't I just be able to navigate to it using SSMS-E? Incidentally, I *AM* able to connect to the database on my desktop if I use Visual Studio and I specify "UserInstance=true". Not specifying "UserInstance=true" results in this error:
An attempt to attach an auto-named database for file C:\Documents and Settings\Robin\Desktop\MyCompany.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Can someone explain what might be causing the problem with SSMS-E, and, for that matter, why it's necessary to specify "UserInstance=true" in Visual Studio?
Thanks so much. I hope these are not too many questions.
Robin
You are attempting to attach a file that is located in a 'protected' storage area -specifically your private 'Desktop'. That file would not be available to other users of the computer. You can attach it to a user instance since that user instance will be restricted for your use only and other users could not access it.
If you want to attach the file to the server, move the file from your 'Desktop' to a storage area accessible for all users of SQL Server.
Sunday, March 25, 2012
Can't attach 2005 DB on Vista - Erland? Anyone? Help me please!
I've installed MSSQL 2005 STD on Vista and now can't attach my
databases.
I've installed SQL SP2 and the SQL Vista Beta Update.
The error I'm getting is:
Unable to open the physical file <Path to MDF>. Operating system error
5: '''5(Error not found)'''. (Microsoft SQL Server, Error: 5120)
Thanks for your help. All your hints are very much appreciated.
Thanks,
Martin N Feuersteiner
Invent2b GroupOn 1 Mar, 14:19, theintrepid...@.hotmail.com wrote:
Quote:
Originally Posted by
Dear Group
>
I've installed MSSQL 2005 STD on Vista and now can't attach my
databases.
I've installed SQL SP2 and the SQL Vista Beta Update.
The error I'm getting is:
>
Unable to open the physical file <Path to MDF>. Operating system error
5: '''5(Error not found)'''. (Microsoft SQL Server, Error: 5120)
Found the Solution on Vista:
- Go to Control Panel and Switch to Classic View
- Click on User Accounts
- Click on Turn User Account Control on or off
- Uncheck use User Account Control (UAC) to help protect your
computer.
- OK
- Restart System
Try again to attach the DB. It should work now.
Hope this helps anyone else having this problem.
Martin
Invent2b Group|||(theintrepidfox@.hotmail.com) writes:
Quote:
Originally Posted by
Found the Solution on Vista:
>
- Go to Control Panel and Switch to Classic View
- Click on User Accounts
- Click on Turn User Account Control on or off
- Uncheck use User Account Control (UAC) to help protect your
computer.
- OK
- Restart System
>
Try again to attach the DB. It should work now.
>
Hope this helps anyone else having this problem.
Maybe a bit heavy-duty. The point with UAC in Vista as I understand it,
is that you should not run as Administrator all the time, only when you
need it. While running as Administrator is convenient, it makes it
easier for any infections your machines may catch to spread. I think
there is a context-menu option "Run As Administrator".
Personally, I have not had any encounter with Vista yet.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On 1 Mar, 22:13, Erland Sommarskog <esq...@.sommarskog.sewrote:
Quote:
Originally Posted by
(theintrepid...@.hotmail.com) writes:
Quote:
Originally Posted by
Found the Solution on Vista:
>
Quote:
Originally Posted by
- Go to Control Panel and Switch to Classic View
- Click on User Accounts
- Click on Turn User Account Control on or off
- Uncheck use User Account Control (UAC) to help protect your
computer.
- OK
- Restart System
>
Quote:
Originally Posted by
Try again to attach the DB. It should work now.
>
Quote:
Originally Posted by
Hope this helps anyone else having this problem.
>
Maybe a bit heavy-duty. The point with UAC in Vista as I understand it,
is that you should not run as Administrator all the time, only when you
need it. While running as Administrator is convenient, it makes it
easier for any infections your machines may catch to spread. I think
there is a context-menu option "Run As Administrator".
>
Personally, I have not had any encounter with Vista yet.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Hi Erland
Correct. It's heavy duty and my first attempt was to right-click on
the Management Studio Icon and to choose the 'Run As Administrator'
option which didn't work.
UAC is indeed a good feature and helps to protect. But following this
process didn't solve the problem and there was no other choice than
having to turn off UAC.
I haven't tried turning UAC on since I attached the databases to see
what its effect is.
To put it short, UAC is good but not in a development environemnt.
Despite having turned it off VS 2005 still warns me that it may not
work correctly, needing Admin rights but it starts fine without any
errors so far. And anyway, what's the REAL risk of having it turned
off. A Vista machine with UAC off won't become less protected than a
XP machine used to be and any additional security software and common
user sense will help protect the same way. I reckon it's rather good
for my dad who clicks on and executes everything he's prompted with.
Bless him and his viruses.
If anyone has a better suggestion to this workaround which will work
with UAC on, please post it here.
All the best,
Martin
Invent2b Group|||(theintrepidfox@.hotmail.com) writes:
Quote:
Originally Posted by
Correct. It's heavy duty and my first attempt was to right-click on
the Management Studio Icon and to choose the 'Run As Administrator'
option which didn't work.
UAC is indeed a good feature and helps to protect. But following this
process didn't solve the problem and there was no other choice than
having to turn off UAC.
I haven't tried turning UAC on since I attached the databases to see
what its effect is.
Having today having had my first encounter with Vista, and I agree that it
is very irritating. (Then again, there seems to be a whole lot of
irritating fluff in Vista. I want to computer to run SQL Server on, I
don't want this "My Music" etc.)
No, I never came as far installing SQL Server. About every second time
I reboot, the machine powers off while Vista is starting. I will probably
change to a different motherboard.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I agree UAC can be annoying on a development box but I've been running Vista
with UAC and haven't had to resort to turning it off. I need to run VS as
administrator. It's optional with SSMS depending on the features I use
(e.g. stop/start services requires admin).
--
Hope this helps.
Dan Guzman
SQL Server MVP
<theintrepidfox@.hotmail.comwrote in message
news:1173031039.763449.115250@.n33g2000cwc.googlegr oups.com...
Quote:
Originally Posted by
On 1 Mar, 22:13, Erland Sommarskog <esq...@.sommarskog.sewrote:
Quote:
Originally Posted by
> (theintrepid...@.hotmail.com) writes:
Quote:
Originally Posted by
Found the Solution on Vista:
>>
Quote:
Originally Posted by
- Go to Control Panel and Switch to Classic View
- Click on User Accounts
- Click on Turn User Account Control on or off
- Uncheck use User Account Control (UAC) to help protect your
computer.
- OK
- Restart System
>>
Quote:
Originally Posted by
Try again to attach the DB. It should work now.
>>
Quote:
Originally Posted by
Hope this helps anyone else having this problem.
>>
>Maybe a bit heavy-duty. The point with UAC in Vista as I understand it,
>is that you should not run as Administrator all the time, only when you
>need it. While running as Administrator is convenient, it makes it
>easier for any infections your machines may catch to spread. I think
>there is a context-menu option "Run As Administrator".
>>
>Personally, I have not had any encounter with Vista yet.
>>
>--
>Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>>
>Books Online for SQL Server 2005
>athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
>Books Online for SQL Server 2000
>athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
Hi Erland
>
Correct. It's heavy duty and my first attempt was to right-click on
the Management Studio Icon and to choose the 'Run As Administrator'
option which didn't work.
UAC is indeed a good feature and helps to protect. But following this
process didn't solve the problem and there was no other choice than
having to turn off UAC.
I haven't tried turning UAC on since I attached the databases to see
what its effect is.
>
To put it short, UAC is good but not in a development environemnt.
Despite having turned it off VS 2005 still warns me that it may not
work correctly, needing Admin rights but it starts fine without any
errors so far. And anyway, what's the REAL risk of having it turned
off. A Vista machine with UAC off won't become less protected than a
XP machine used to be and any additional security software and common
user sense will help protect the same way. I reckon it's rather good
for my dad who clicks on and executes everything he's prompted with.
Bless him and his viruses.
>
If anyone has a better suggestion to this workaround which will work
with UAC on, please post it here.
>
All the best,
>
Martin
Invent2b Group
>|||>
Quote:
Originally Posted by
No, I never came as far installing SQL Server. About every second time
I reboot, the machine powers off while Vista is starting. I will probably
change to a different motherboard.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
How does Vista behave if you install it on a non Vista PC under
Virtual PC 2007?
It does reboot during setup start-up without warning and a blank
screen but else it's much more stable and fine. Just setting up SBS
and some client PCs under Virtual Server on it.
I had that rebooting thing during startup and freezing with three PCs
(non Vista) until it turned out to be a really nasty virus despite
running all sorts of virus checks.
The solution was to actually take the drive out, and stick it as a
slave in another PC with up-to date Free AVG running which actually
detected that bugger.
The only thing that still bugs me with Vista is, and I think it's a
Vista issue, I doesn't list the databases on the SQL Server when
trying to connect (connecting is fine) to an existing instance from
Outlook Business Contact Manager. Checked all the SQL security,
logins, protocols. Any idea?
Thursday, March 22, 2012
Cant Add new connection in SQL SERVER EXPRESS
Hi,
I am relatively new to this. I have installed VB 2005 and that has installed a version of SQL Server 2005 Express on my local development machine. I am using VB to develop some demo sites and i can create DB's in the App_Data file and they work when I test and run then by pressing Ctrl + F5.
However i have some demo tutorials that require Northwind and Pubs to do them. So i have installed Northwind and Pubs using the cms prompt and the InstNwnd.sql install. They said everything has been installed fine.
This is where the problem starts. I open new connection in VB, or asses for that matter and try to open my local server machine (just my desktop running WindowsXP pro), Which is called Optiplex. Sometimes i get the optiplex appear in the dropdown that asks for your to choose a server and other times it doesnt. Eevn if the machine appears it doesnt let me chose Pubs or northwind from the second drop down.
I think i must have SQexpress running on the machined named Optiplex because i have the SQL server configuartion manger on it. That tells me i am running SQL Server(SQLEXPRESS) and SQL Server Browser both switched on and running. By the way i have set my SQL manager to run as Local service.
One thing that i consider strange is that when i have had SQLServer Express running on other machines normally there was a little icon running in the right hand corner of the the task bar.
Does anyone know what is going on with my mchine and have i got the SQL server setup correctly?
Just one last piece of additionally information is that i have a folder called C:\SQL Server 2000 Sample Databases which is where the MDF files are located.
Thanks a million Sanson
Hi Sanson,
Could you give me some more details? Which database will the appliation connect to? SQL Server 2005 Express or SQL Server 2000 ? You mentioned that you have a folder called C:\SQL Server 200 Sample Database which is where the MDF files located, Have these MDF files (Northwind and Pubs) be attached to SQL Server by using Management Satudio? If not,pls follow the steps below:
1. Copy your .mdf file and .ldf(if exists) to another folder.
2. Right click on Databases, and select Attach from the popup menu.
3. In the Attach Databases dialog box,click Add button and select the .mdf file.
4. Click OK to finish, and the database will be atached to your database list in Management Studio.
Thanks.
|||Thanks for your help.
What had happened was i hadnt installed SQL Management Studio. Once i did everything got sorted out and they were in there.
However i still cant use the upsizing wizard in Access to upsize a database to SQL. I always get a connect error.
Now however i get a the name of my server come up in the dropdown box, which is somethong i suppose.
sqlCan't add DataSource or connect to database with Wizard
I installed Visual Studio 2005 Beta 2 and could connect with it to my SQL 2000 Server. Now I installed on the same laptop SQL Server 2005, but the installation failed on some error. Now I uninstalled SQL Server 2005, but now I can't connect anymore to any datasource. The "Add new Data Source" is just not highlited and the Wizard from Tools Menu "Connect to Database" does not launch at all.
Any one has a solution?
thanks,
ImmanuelThe solution was to repair the Visual Studio 2005 installation.
Can't add a SQL Database (2005 Express Edition) to a C# Project over RDP
I installed C# with SQL Server 2005 Express Edition. Everything works fine on the account I installed it on, on the local machine. However.
1) I can't connect using RDP to that same account and use SQL. It times out.
2) Other users on that computer cannot make user of SQL. Also times out.
I couldn't find documentation on these issues.
Thanks,
Philski
When you first set up the SQL Express edition the system installs with the networking systems turned off. You will need to activate the remote connections on the sql server express system by using the SQL Server Configuration Manager tools. (These should have also been installed when you installed the sql express system)
|||Didn't work.Not sure why i should need to open TCP or memory pipes anyways, since RDP is just a reflection of the desktop, and local users do not need a network connection.
I get the same error message when I try to add a database to my C# project, "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed"
Thanks,
Philski|||
Phil, here is a thread from the DB Engine forum that seems to address this issue. Were you logged into the box through TS or on the box locally?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=116459&SiteID=1
Thanks,
Sam Lester (MSFT)
Can't acess RS2005 in a domain environment?!
I have installed SQL 2005 on server A and RS 2005 on server B.
server C is the domain controller.
Every thing works fine when i browse the virtual directories on the local
machine (B).
When i try to acess RS virtual directories from my XPSP2/IE7 workstation i
am prompted for windows credentials, but i keep getting "You are not
authorize to view this page" even though my domain account is a memeber of
Administrators on RS2005 server B. it happens with other XP clients as well.
Why is that? What is wrong here?
the RS2005 has its default installation base on the windows authentication
method for the virtual directories.
rs2005 settings are:
website: defaul
SSL: NO
Windows service identity: Local system
Web service identity: application pool "ap1" with my domain account (member
of local admin group)
db setup: SQL server login = 'sa'
thanks in advance
rafiOn Jan 9, 4:39 am, Rafi <R...@.discussions.microsoft.com> wrote:
> hi,
> I have installed SQL 2005 on server A and RS 2005 on server B.
> server C is the domain controller.
> Every thing works fine when i browse the virtual directories on the local
> machine (B).
> When i try to acess RS virtual directories from my XPSP2/IE7 workstation i
> am prompted for windows credentials, but i keep getting "You are not
> authorize to view this page" even though my domain account is a memeber of
> Administrators on RS2005 server B. it happens with other XP clients as well.
> Why is that? What is wrong here?
> the RS2005 has its default installation base on the windows authentication
> method for the virtual directories.
> rs2005 settings are:
> website: defaul
> SSL: NO
> Windows service identity: Local system
> Web service identity: application pool "ap1" with my domain account (member
> of local admin group)
> db setup: SQL server login = 'sa'
> thanks in advance
> rafi
Are you allowing anonymous access to the Reports and ReportServer
virtual directories? This could be the problem. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||no. anonymous access is not enabled.
only "Integrated windows auth.." is marked.
i always prompted for my domain credentials when using a browser from XP
xlient while i am loged in with my domain account
still need help!
Rafi
"EMartinez" wrote:
> On Jan 9, 4:39 am, Rafi <R...@.discussions.microsoft.com> wrote:
> > hi,
> >
> > I have installed SQL 2005 on server A and RS 2005 on server B.
> > server C is the domain controller.
> > Every thing works fine when i browse the virtual directories on the local
> > machine (B).
> >
> > When i try to acess RS virtual directories from my XPSP2/IE7 workstation i
> > am prompted for windows credentials, but i keep getting "You are not
> > authorize to view this page" even though my domain account is a memeber of
> > Administrators on RS2005 server B. it happens with other XP clients as well.
> >
> > Why is that? What is wrong here?
> >
> > the RS2005 has its default installation base on the windows authentication
> > method for the virtual directories.
> >
> > rs2005 settings are:
> > website: defaul
> > SSL: NO
> > Windows service identity: Local system
> > Web service identity: application pool "ap1" with my domain account (member
> > of local admin group)
> > db setup: SQL server login = 'sa'
> >
> > thanks in advance
> >
> > rafi
>
> Are you allowing anonymous access to the Reports and ReportServer
> virtual directories? This could be the problem. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Check the following:
ReportServer and Reports virtual directory should set for windows
authentication.
Start a command prompt, then navigate to the C:\Inetpub\Adminscripts
folder
where the adsutil.vbs located.
Check the authentication providers with this in the command prompt:
cscript
adsutil.vbs get w3svc/NTAuthenticationProviders
If you get "The parameter "NTAuthenticationProviders" is not set at
this
node" message, then type cscript adsutil.vbs set
w3svc/NTAuthenticationProviders "NTLM" in cmd. After this try to open
the
report manager from a remote machine.
I hope this solves the problem.
Regards,
Bob
On Jan 13, 1:53=A0am, Rafi <R...@.discussions.microsoft.com> wrote:
> no. anonymous access is not enabled.
> only "Integratedwindowsauth.." is marked.
> i always prompted for my domain credentials when using a browser from XP
> xlient while i am =A0loged in with my domain account
> still need help!
> Rafi
>
> "EMartinez" wrote:
> > On Jan 9, 4:39 am, Rafi <R...@.discussions.microsoft.com> wrote:
> > > hi,
> > > I have installed SQL 2005 on server A and RS 2005 on server B.
> > > server C is the domain controller.
> > > Every thing works fine when i browse the virtual directories on the lo=cal
> > > machine (B).
> > > When i try to acess RS virtual directories from my XPSP2/IE7 workstati=on i
> > > am prompted forwindowscredentials, but i keep getting "You are not
> > > authorize to view this page" even though my domain account is a memebe=r of
> > > Administrators onRS2005server B. it happens with other XP clients as w=ell.
> > > Why is that? What is wrong here?
> > > theRS2005has its default installation base on thewindowsauthentication=
> > > method for the virtual directories.
> > >rs2005settings are:
> > > website: defaul
> > > SSL: NO
> > >Windowsserviceidentity: Local system
> > > Webserviceidentity: =A0application pool "ap1" with my domain account (=member
> > > of local admin group)
> > > db setup: SQL server login =3D 'sa'
> > > thanks in =A0advance
> > > rafi
> > Are you allowing anonymous access to the Reports and ReportServer
> > virtual directories? This could be the problem. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
Can't access SQL Server Reporting Services URL anymore
We've had a Reporting Services installation for nearly 6 months now with no
problems. Reporting Services is installed on a Windows 2003 machine which is
connecting to SQL Server 2000 databases.
This morning, it was reporting that the URL to access the report server
(http://server/reports) is returning the following error message:
The report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing.
(rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.
Not sure where to go from here. Nothing has changed as far as we can tell.
Thanks,
JasonThere's also an error in the event log of the Reporting Services machine that
states:
Report Server cannot connect to the report server database.
How do I re-establish this connection? The database still resides on the
same server, same name as before. I am not sure how this happened.
"Jason" wrote:
> Hi all,
> We've had a Reporting Services installation for nearly 6 months now with no
> problems. Reporting Services is installed on a Windows 2003 machine which is
> connecting to SQL Server 2000 databases.
> This morning, it was reporting that the URL to access the report server
> (http://server/reports) is returning the following error message:
>
> The report server cannot open a connection to the report server database. A
> connection to the database is required for all requests and processing.
> (rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
> '(null)'. Reason: Not associated with a trusted SQL Server connection.
>
> Not sure where to go from here. Nothing has changed as far as we can tell.
> Thanks,
> Jason
>
Cant Access SQL Server (on Vista) from other Network PC (XP)
I have just installed Vista on one of my home network pcs. I also installed Outlook 2005 with Business Contact Manager. It installs an instance of SQL Server Express.
I have created another database on this engine that I need to access from other PCs on my network.
The server address is PCNAME\MSSMLBIZ and I can access the data the database using this name from the the Vista PC (PCNAME).
When I try to acess the database using the same credentials (server, database, username (sa) and password) from an XP PC on the network - it times out and returns an error . My guess is that it is not seeing the database service at all.
I have SQL Server Management Studio installed on the Vista PC and have full access to the instance.
Server authentication is set for SQL Server and Windows Authentication mode.
Can anyone help me?. I need to access the SQL Server from the XP PC.
Ian
Make sure that SQL Server Browser is running, you firewall is configured properly to allow the SQL Server traffic and that Remote connections are enabled for SQL Server. (See the screencats on my site for more information).
Firewall configuration: http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b914277
Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Yes - that worked - as soon as I set remote access on Surface Area Configuration for Services and Connections page.
Regards Ian
|||I have just installed SQL Server 2005 Developer Edition on Windows Vista Ultimate, but i cant access and see "sql server managment studio" The only things i have are these >>>Cant Access SQL Server (on Vista)
I have just installed Vista on one of my home network pcs. I also installed Outlook 2005 with Business Contact Manager. It installs an instance of SQL Server Express.
I have created another database on this engine that I need to access from other PCs on my network.
The server address is PCNAME\MSSMLBIZ and I can access the data the database using this name from the the Vista PC (PCNAME).
When I try to acess the database using the same credentials (server, database, username (sa) and password) from an XP PC on the network - it times out and returns an error . My guess is that it is not seeing the database service at all.
I have SQL Server Management Studio installed on the Vista PC and have full access to the instance.
Server authentication is set for SQL Server and Windows Authentication mode.
Can anyone help me?. I need to access the SQL Server from the XP PC.
Ian
Make sure that SQL Server Browser is running, you firewall is configured properly to allow the SQL Server traffic and that Remote connections are enabled for SQL Server. (See the screencats on my site for more information).
Firewall configuration: http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b914277
Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Yes - that worked - as soon as I set remote access on Surface Area Configuration for Services and Connections page.
Regards Ian
|||I have just installed SQL Server 2005 Developer Edition on Windows Vista Ultimate, but i cant access and see "sql server managment studio" The only things i have are these >>>Can't access SQL Express from SQL Server
haven't been able to connect to it from SQL Server which is running on the
same network, but on our real server. Now I have been able to successfully
able to connect to the real SQL Server from the Express but it doesn't work
the other way around. I am using the same hostname that I see in the
Express managment studio... \\PARENTVM\SQLEXPRESS using the login I created
in Express.
I allowed access through Windows Firewall, and I enabled the allow access
from remote users in the Express configuration.
What am I missing?
Hi there,
Have you enabled remote connections on the SQLExpress instance?
By default the remote connections are disabled. Open "SQL Server
Surface Area Configuration" under Configuration tools. You then need to
select the "Surface Area Configuration for Services and Connections"
option. The Remote connections option will allow you to change the
connection types. Once you've done that restart the service to make
sure the change takes effect.
Hope this help...
sql