Microsofts Sql web admin and sqldmo

Hello all,

has anyone had the opportunity to try the sql web admin tool? if so, i have one question.

How can i use this to connect to a remote sql/msde server?

in the server textbox on the login screen i try 'machine name'\'instance name', along with the sa username and password. This does not work however.

am i just entering the wrong value , or do i need to change the code of the .connect method to allow for remote connections?

TIA.

-C-By "does not work", do you mean you are getting an error?

I have been successful using Web Data Administrator to connect to a remote database. The remote database must have mixed authentication (SQL Server and Windows). and you must be using a valid login and password. I accessed the server using the IP address.

As an additional point, I was VPN authenticated on the remote network before connecting.

Terri

Microsoft’s SQL Server Version support

Does anybody no where Microsoft publishes a listing of supported SQL Server versions with final support dates?

Thanks,

Dave

Here you go:

http://support.microsoft.com/lifecycle/search/?sort=PN&alpha=sql+server&x=8&y=10

Peter

Microsoft SSMSE - Printing database layout?

I'm connected to my remote SQL 2000 server using Microsofts SQL Server
Management Studio Express.
I can't see any way to print out my database table properties. Under
Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
which does not work.
How does one print out the layout of their database from this app?
Thanks!Noozer
Do you want to print a diagram by using SSMS of the SQL Server 2000
database?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
> Management Studio Express.
> I can't see any way to print out my database table properties. Under
> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
> which does not work.
> How does one print out the layout of their database from this app?
> Thanks!
>|||Diagrams would be great!
But, I'd settle for simply printing the properties from each of my tables.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
> Noozer
> Do you want to print a diagram by using SSMS of the SQL Server 2000
> database?
>
>
> "Noozer" <dont.spam@.me.here> wrote in message
> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
>> which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>|||Noozer
What properties? There is an option Script Table As , are you talking about
this feature?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Diagrams would be great!
> But, I'd settle for simply printing the properties from each of my tables.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>> Noozer
>> Do you want to print a diagram by using SSMS of the SQL Server 2000
>> database?
>>
>>
>> "Noozer" <dont.spam@.me.here> wrote in message
>> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
>> which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>>
>|||Why can't you go to File, Print...
or right-click the db diagram, "Copy Diagram to Clipboard," and paste/print
from Word?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Diagrams would be great!
> But, I'd settle for simply printing the properties from each of my tables.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>> Noozer
>> Do you want to print a diagram by using SSMS of the SQL Server 2000
>> database?
>>
>>
>> "Noozer" <dont.spam@.me.here> wrote in message
>> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
>> which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>>
>|||Because "Print..." is coming up disabled.
The server is a remote MS SQL 2000 server.
Diagrams does not work at all.
"JFoushee" <someone@.somewhere-donotspam.com> wrote in message
news:O$O9PTRbGHA.4116@.TK2MSFTNGP05.phx.gbl...
> Why can't you go to File, Print...
> or right-click the db diagram, "Copy Diagram to Clipboard," and
> paste/print from Word?
> "Noozer" <dont.spam@.me.here> wrote in message
> news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
>> Diagrams would be great!
>> But, I'd settle for simply printing the properties from each of my
>> tables.
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>> Noozer
>> Do you want to print a diagram by using SSMS of the SQL Server 2000
>> database?
>>
>>
>> "Noozer" <dont.spam@.me.here> wrote in message
>> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000
>> Diagrams", which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>>
>>
>

Microsoft SSMSE - Printing database layout?

I'm connected to my remote SQL 2000 server using Microsofts SQL Server
Management Studio Express.
I can't see any way to print out my database table properties. Under
Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
which does not work.
How does one print out the layout of their database from this app?
Thanks!Noozer
Do you want to print a diagram by using SSMS of the SQL Server 2000
database?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
> Management Studio Express.
> I can't see any way to print out my database table properties. Under
> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
> which does not work.
> How does one print out the layout of their database from this app?
> Thanks!
>|||Diagrams would be great!
But, I'd settle for simply printing the properties from each of my tables.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
> Noozer
> Do you want to print a diagram by using SSMS of the SQL Server 2000
> database?
>
>
> "Noozer" <dont.spam@.me.here> wrote in message
> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>|||Noozer
What properties? There is an option Script Table As , are you talking about
this feature?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Diagrams would be great!
> But, I'd settle for simply printing the properties from each of my tables.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>|||Why can't you go to File, Print...
or right-click the db diagram, "Copy Diagram to Clipboard," and paste/print
from Word?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Diagrams would be great!
> But, I'd settle for simply printing the properties from each of my tables.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>|||Because "Print..." is coming up disabled.
The server is a remote MS SQL 2000 server.
Diagrams does not work at all.
"JFoushee" <someone@.somewhere-donotspam.com> wrote in message
news:O$O9PTRbGHA.4116@.TK2MSFTNGP05.phx.gbl...
> Why can't you go to File, Print...
> or right-click the db diagram, "Copy Diagram to Clipboard," and
> paste/print from Word?
> "Noozer" <dont.spam@.me.here> wrote in message
> news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
>