Remote View Question

I am connecting through EM to another SQL server for my web
site, is there a way to limit it so that I only see my database and
not all the 100's of others that are listed.

Also, sorry if this sounds dumb but I applied the sp3 sevice
pack and I dont know how to verify this, normallly one would go to
help>about and see it there, there was a sp3 and a sp3a, but a
friend told me to only apply the sp3, needless to say it seems slow
connecting and I would like to verify that everything is in working
order.

Thank You

Reply to newsgroup as email address is bogus due to spam

MichaelIn the query analyzer run the command: @.@.version. When your version
numbver shows 8.00.760 SP3 is installed. Have a look at this website:
http://www.krell-software.com/mssql-builds.htm for all version numbers
of sql-server.

There is no reason not to install SP3a !!!

Hiding database in the EM is just not possible:

"There is not a way to hide the databases in Enterprise Manager. It
does not
have that capability. The database listing comes from the sysdatabases
table and there is no way to filter the data to hide the databases the
user
does not have access to"

Greetings Sjaak|||MiKeY <Mikey@.yahoo.com> wrote in message news:<anhksvc3gnc041ib7snqh6chbgnpttlrhd@.4ax.com>...
> I am connecting through EM to another SQL server for my web
> site, is there a way to limit it so that I only see my database and
> not all the 100's of others that are listed.
> Also, sorry if this sounds dumb but I applied the sp3 sevice
> pack and I dont know how to verify this, normallly one would go to
> help>about and see it there, there was a sp3 and a sp3a, but a
> friend told me to only apply the sp3, needless to say it seems slow
> connecting and I would like to verify that everything is in working
> order.
>
> Thank You
> Reply to newsgroup as email address is bogus due to spam
>
> Michael

EM always displays all databases on the server; QA displays only the
ones you have access to. But connecting with QA probably won't be any
faster, because it has the check all databases to see if you can
access them. From the server side, if any databases are set to
autoclose, then populating the list in EM can be very slow, but if you
are not the DBA or if the server is with an ISP, then there's probably
not much you can do about that.

As for identifying the servicepack, on the client you can check the
version number in Help-About in QA; for the server you can check this
KB article:

http://support.microsoft.com/defaul...b;en-us;q321185

Simonsql

Remote Connections error

While trying to transfer my website project to another computer I am encountering an error when tryng to run the solution. It gives me a "Does not allow remote connections". Why is this when on the original computer everything worked fine.

Walter

Does the error has anything to do with SQL server?

This error is common when there is a connection problem to SQL server.

Verify your connection string.Make sure SQL server is running. Make sure you are able to connect to the database.

Regards,

David

|||

I think I had an error similar to this before and therefore I'll assume that your problem is like mine and is associated with SQL Server. (I thinkneutrino is of the same persuasion.)

Now if I understand you correctly, you're trying to run a project on one pc and connect to a database on another pc. Therefore I think the problem is that SQL Server is rejecting your remote connection because it's not configured to accept it! You need to allow remote connections to that server.

See this article (How to configure SQL Server 2005 to allow remote connections ).

Now.. if you're problem isn't related to SQL Server ... well.. Ignore all of the above.

Remote Connection to file-based Express DB

Hi,

This might be obvious - but if so I've missed it so far.

Is it possible to connect remotely to an Express database used in a website which is created in the App_Data folder by VWDEE 2005 and attached by filename?

As far as I can tell these databases don't have a name and aren't mounted until an attempt is made to access them. I certainly can't see any sign of it in SQL Management Studio.

Thanks,

Dale

Hi Dale,

SQL Express only connects to local files; you can't connect as you suggest.

Regards,

Mike Wachal
SQL Express team

|||

Hi Mike - thanks for your reply.

Just to clarify further if I use an SQL Server 2005 Express database as part of my web app hosted with my web site; the only way I can remotely access the data in that database is by physically copying the database locally - essentually the same as if I used an MS Access database?

Cheers,

Mike Wachal - MSFT wrote:

Hi Dale,

SQL Express only connects to local files; you can't connect as you suggest.

Regards,

Mike Wachal
SQL Express team

Remote Connection to file-based Express DB

Hi,

This might be obvious - but if so I've missed it so far.

Is it possible to connect remotely to an Express database used in a website which is created in the App_Data folder by VWDEE 2005 and attached by filename?

As far as I can tell these databases don't have a name and aren't mounted until an attempt is made to access them. I certainly can't see any sign of it in SQL Management Studio.

Thanks,

Dale

Hi Dale,

SQL Express only connects to local files; you can't connect as you suggest.

Regards,

Mike Wachal
SQL Express team

|||

Hi Mike - thanks for your reply.

Just to clarify further if I use an SQL Server 2005 Express database as part of my web app hosted with my web site; the only way I can remotely access the data in that database is by physically copying the database locally - essentually the same as if I used an MS Access database?

Cheers,

Mike Wachal - MSFT wrote:

Hi Dale,

SQL Express only connects to local files; you can't connect as you suggest.

Regards,

Mike Wachal
SQL Express team

Remote Connection to file-based Express DB

Hi,

This might be obvious - but if so I've missed it so far.

Is it possible to connect remotely to an Express database used in a website which is created in the App_Data folder by VWDEE 2005 and attached by filename?

As far as I can tell these databases don't have a name and aren't mounted until an attempt is made to access them. I certainly can't see any sign of it in SQL Management Studio.

Thanks,

Dale

Hi Dale,

SQL Express only connects to local files; you can't connect as you suggest.

Regards,

Mike Wachal
SQL Express team

|||

Hi Mike - thanks for your reply.

Just to clarify further if I use an SQL Server 2005 Express database as part of my web app hosted with my web site; the only way I can remotely access the data in that database is by physically copying the database locally - essentually the same as if I used an MS Access database?

Cheers,

Mike Wachal - MSFT wrote:

Hi Dale,

SQL Express only connects to local files; you can't connect as you suggest.

Regards,

Mike Wachal
SQL Express team