Hi
I do not want to install SQL server client on every user machine.
I want to give users access from browser to the sqlserver 2000 database.
Is it possible?
I saw sqlserver webadministrator?
From the name it looks like a administration tool?
Thanks
Mangesh
"SQL Server Web Data Administrator"
http://www.microsoft.com/downloads/d...displaylang=en
Cristian Lefter, SQL Server MVP
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:8B328C00-790E-4FD0-82F3-022F3C6ABA40@.microsoft.com...
> Hi
> I do not want to install SQL server client on every user machine.
> I want to give users access from browser to the sqlserver 2000 database.
> Is it possible?
> I saw sqlserver webadministrator?
> From the name it looks like a administration tool?
> Thanks
> Mangesh
Showing posts with label install. Show all posts
Showing posts with label install. Show all posts
Sunday, March 11, 2012
access to sqlserver database from web
Hi
I do not want to install SQL server client on every user machine.
I want to give users access from browser to the sqlserver 2000 database.
Is it possible?
I saw sqlserver webadministrator?
From the name it looks like a administration tool'
Thanks
Mangesh"SQL Server Web Data Administrator"
http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en
Cristian Lefter, SQL Server MVP
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:8B328C00-790E-4FD0-82F3-022F3C6ABA40@.microsoft.com...
> Hi
> I do not want to install SQL server client on every user machine.
> I want to give users access from browser to the sqlserver 2000 database.
> Is it possible?
> I saw sqlserver webadministrator?
> From the name it looks like a administration tool'
> Thanks
> Mangesh
I do not want to install SQL server client on every user machine.
I want to give users access from browser to the sqlserver 2000 database.
Is it possible?
I saw sqlserver webadministrator?
From the name it looks like a administration tool'
Thanks
Mangesh"SQL Server Web Data Administrator"
http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en
Cristian Lefter, SQL Server MVP
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:8B328C00-790E-4FD0-82F3-022F3C6ABA40@.microsoft.com...
> Hi
> I do not want to install SQL server client on every user machine.
> I want to give users access from browser to the sqlserver 2000 database.
> Is it possible?
> I saw sqlserver webadministrator?
> From the name it looks like a administration tool'
> Thanks
> Mangesh
access to sqlserver database from web
Hi
I do not want to install SQL server client on every user machine.
I want to give users access from browser to the sqlserver 2000 database.
Is it possible?
I saw sqlserver webadministrator?
From the name it looks like a administration tool'
Thanks
Mangesh"SQL Server Web Data Administrator"
http://www.microsoft.com/downloads/...&displaylang=en
Cristian Lefter, SQL Server MVP
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:8B328C00-790E-4FD0-82F3-022F3C6ABA40@.microsoft.com...
> Hi
> I do not want to install SQL server client on every user machine.
> I want to give users access from browser to the sqlserver 2000 database.
> Is it possible?
> I saw sqlserver webadministrator?
> From the name it looks like a administration tool'
> Thanks
> Mangesh
I do not want to install SQL server client on every user machine.
I want to give users access from browser to the sqlserver 2000 database.
Is it possible?
I saw sqlserver webadministrator?
From the name it looks like a administration tool'
Thanks
Mangesh"SQL Server Web Data Administrator"
http://www.microsoft.com/downloads/...&displaylang=en
Cristian Lefter, SQL Server MVP
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:8B328C00-790E-4FD0-82F3-022F3C6ABA40@.microsoft.com...
> Hi
> I do not want to install SQL server client on every user machine.
> I want to give users access from browser to the sqlserver 2000 database.
> Is it possible?
> I saw sqlserver webadministrator?
> From the name it looks like a administration tool'
> Thanks
> Mangesh
Thursday, March 8, 2012
Access to sql server
I am writed handreds page in my wwwroot use Access Database,and I install a SQL server yestoday,What should I do after move my database to sql server .
thanks!With the Access Database you are probably using OleDbDataAdapters and OleDbCommands. With SqlServer you should use SqlDataAdapters and SqlCommands because they are more efficient. The syntax between the two is very similar so mostly you'll just need to change the class names (OleDbxxx to Sqlxxx).
thanks!With the Access Database you are probably using OleDbDataAdapters and OleDbCommands. With SqlServer you should use SqlDataAdapters and SqlCommands because they are more efficient. The syntax between the two is very similar so mostly you'll just need to change the class names (OleDbxxx to Sqlxxx).
If you're using any Access specific Sql commands you will have to modify them for SqlServer. For example Access uses "IIF(x,y,z)" while Sql Server uses "CASE WHEN x THEN y ELSE z END".
access to SQL from non-domain PC via Enterprise Manager
I have a developer on contract which will use her laptop to work, laptop is
not part of the domain, we install SQL tools on it and now I need to give th
at person access to one of our SQL databases, so I created sql user and then
try to register this serve
r on her laptop in Enterprise Menager but getting error “server is not run
ning or you do no have an access to it” how do bypass it? I have not pro
blem to register this server in Enterprise Manager on my PC using same sql u
ser but my PC is part of do
main, any idea?Make sure they are using TCP/IP to connect. You can force this by setting up
a client alias using the Client Network Utility. Also, try connecting using
Query Analyzer rather than EM and specifying tcp:servername in the
connection dialog to force it to use TCP/IP rather than Named pipes
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"TOM P." <TOMP@.discussions.microsoft.com> wrote in message
news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> I have a developer on contract which will use her laptop to work, laptop
is not part of the domain, we install SQL tools on it and now I need to give
that person access to one of our SQL databases, so I created sql user and
then try to register this server on her laptop in Enterprise Menager but
getting error "server is not running or you do no have an access to it"
how do bypass it? I have not problem to register this server in Enterprise
Manager on my PC using same sql user but my PC is part of domain, any idea?|||Thanks,
I have figuered it out, anyway thanks for respond... that's exactly what I h
ad to do creat Alias using TCPIP
Thanks again
"Jasper Smith" wrote:
> Make sure they are using TCP/IP to connect. You can force this by setting
up
> a client alias using the Client Network Utility. Also, try connecting usin
g
> Query Analyzer rather than EM and specifying tcp:servername in the
> connection dialog to force it to use TCP/IP rather than Named pipes
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "TOM P." <TOMP@.discussions.microsoft.com> wrote in message
> news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> is not part of the domain, we install SQL tools on it and now I need to gi
ve
> that person access to one of our SQL databases, so I created sql user and
> then try to register this server on her laptop in Enterprise Menager but
> getting error "server is not running or you do no have an access to it"
> how do bypass it? I have not problem to register this server in Enterprise
> Manager on my PC using same sql user but my PC is part of domain, any idea
?
>
>
not part of the domain, we install SQL tools on it and now I need to give th
at person access to one of our SQL databases, so I created sql user and then
try to register this serve
r on her laptop in Enterprise Menager but getting error “server is not run
ning or you do no have an access to it” how do bypass it? I have not pro
blem to register this server in Enterprise Manager on my PC using same sql u
ser but my PC is part of do
main, any idea?Make sure they are using TCP/IP to connect. You can force this by setting up
a client alias using the Client Network Utility. Also, try connecting using
Query Analyzer rather than EM and specifying tcp:servername in the
connection dialog to force it to use TCP/IP rather than Named pipes
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"TOM P." <TOMP@.discussions.microsoft.com> wrote in message
news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> I have a developer on contract which will use her laptop to work, laptop
is not part of the domain, we install SQL tools on it and now I need to give
that person access to one of our SQL databases, so I created sql user and
then try to register this server on her laptop in Enterprise Menager but
getting error "server is not running or you do no have an access to it"
how do bypass it? I have not problem to register this server in Enterprise
Manager on my PC using same sql user but my PC is part of domain, any idea?|||Thanks,
I have figuered it out, anyway thanks for respond... that's exactly what I h
ad to do creat Alias using TCPIP
Thanks again
"Jasper Smith" wrote:
> Make sure they are using TCP/IP to connect. You can force this by setting
up
> a client alias using the Client Network Utility. Also, try connecting usin
g
> Query Analyzer rather than EM and specifying tcp:servername in the
> connection dialog to force it to use TCP/IP rather than Named pipes
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "TOM P." <TOMP@.discussions.microsoft.com> wrote in message
> news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> is not part of the domain, we install SQL tools on it and now I need to gi
ve
> that person access to one of our SQL databases, so I created sql user and
> then try to register this server on her laptop in Enterprise Menager but
> getting error "server is not running or you do no have an access to it"
> how do bypass it? I have not problem to register this server in Enterprise
> Manager on my PC using same sql user but my PC is part of domain, any idea
?
>
>
access to SQL from non-domain PC via Enterprise Manager
I have a developer on contract which will use her laptop to work, laptop is not part of the domain, we install SQL tools on it and now I need to give that person access to one of our SQL databases, so I created sql user and then try to register this serve
r on her laptop in Enterprise Menager but getting error “server is not running or you do no have an access to it” how do bypass it? I have not problem to register this server in Enterprise Manager on my PC using same sql user but my PC is part of do
main, any idea?
Make sure they are using TCP/IP to connect. You can force this by setting up
a client alias using the Client Network Utility. Also, try connecting using
Query Analyzer rather than EM and specifying tcp:servername in the
connection dialog to force it to use TCP/IP rather than Named pipes
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"TOM P." <TOMP@.discussions.microsoft.com> wrote in message
news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> I have a developer on contract which will use her laptop to work, laptop
is not part of the domain, we install SQL tools on it and now I need to give
that person access to one of our SQL databases, so I created sql user and
then try to register this server on her laptop in Enterprise Menager but
getting error "server is not running or you do no have an access to it"
how do bypass it? I have not problem to register this server in Enterprise
Manager on my PC using same sql user but my PC is part of domain, any idea?
|||Thanks,
I have figuered it out, anyway thanks for respond... that's exactly what I had to do creat Alias using TCPIP
Thanks again
"Jasper Smith" wrote:
> Make sure they are using TCP/IP to connect. You can force this by setting up
> a client alias using the Client Network Utility. Also, try connecting using
> Query Analyzer rather than EM and specifying tcp:servername in the
> connection dialog to force it to use TCP/IP rather than Named pipes
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "TOM P." <TOMP@.discussions.microsoft.com> wrote in message
> news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> is not part of the domain, we install SQL tools on it and now I need to give
> that person access to one of our SQL databases, so I created sql user and
> then try to register this server on her laptop in Enterprise Menager but
> getting error "server is not running or you do no have an access to it"
> how do bypass it? I have not problem to register this server in Enterprise
> Manager on my PC using same sql user but my PC is part of domain, any idea?
>
>
r on her laptop in Enterprise Menager but getting error “server is not running or you do no have an access to it” how do bypass it? I have not problem to register this server in Enterprise Manager on my PC using same sql user but my PC is part of do
main, any idea?
Make sure they are using TCP/IP to connect. You can force this by setting up
a client alias using the Client Network Utility. Also, try connecting using
Query Analyzer rather than EM and specifying tcp:servername in the
connection dialog to force it to use TCP/IP rather than Named pipes
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"TOM P." <TOMP@.discussions.microsoft.com> wrote in message
news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> I have a developer on contract which will use her laptop to work, laptop
is not part of the domain, we install SQL tools on it and now I need to give
that person access to one of our SQL databases, so I created sql user and
then try to register this server on her laptop in Enterprise Menager but
getting error "server is not running or you do no have an access to it"
how do bypass it? I have not problem to register this server in Enterprise
Manager on my PC using same sql user but my PC is part of domain, any idea?
|||Thanks,
I have figuered it out, anyway thanks for respond... that's exactly what I had to do creat Alias using TCPIP
Thanks again
"Jasper Smith" wrote:
> Make sure they are using TCP/IP to connect. You can force this by setting up
> a client alias using the Client Network Utility. Also, try connecting using
> Query Analyzer rather than EM and specifying tcp:servername in the
> connection dialog to force it to use TCP/IP rather than Named pipes
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "TOM P." <TOMP@.discussions.microsoft.com> wrote in message
> news:C1F92B39-7CAB-4649-8645-DBEF1D0EC2E4@.microsoft.com...
> is not part of the domain, we install SQL tools on it and now I need to give
> that person access to one of our SQL databases, so I created sql user and
> then try to register this server on her laptop in Enterprise Menager but
> getting error "server is not running or you do no have an access to it"
> how do bypass it? I have not problem to register this server in Enterprise
> Manager on my PC using same sql user but my PC is part of domain, any idea?
>
>
Friday, February 24, 2012
Access Project with MSDE2000
Hi Gurus,
I've got a question when using Access Project with MSDE2000. I can properly install MSDE and connect a Access Project with master database, but I can't create table or modify table structure, is there any thing wrong?
My os is XP, and Access 2000.
Thanks in advance
You probably dont want to be creating tables within the master db anyway.
When you load Access, chose 'Project (New Data)'. This should allow you to
create your own db, which you should be able to create tables in...
Cheers,
James Goodman
"Frank" <anonymous@.discussions.microsoft.com> wrote in message
news:4F160968-BBDD-4BEE-A13D-03ED349A3659@.microsoft.com...
> Hi Gurus,
> I've got a question when using Access Project with MSDE2000. I can
properly install MSDE and connect a Access Project with master database, but
I can't create table or modify table structure, is there any thing wrong?
> My os is XP, and Access 2000.
> Thanks in advance
>
I've got a question when using Access Project with MSDE2000. I can properly install MSDE and connect a Access Project with master database, but I can't create table or modify table structure, is there any thing wrong?
My os is XP, and Access 2000.
Thanks in advance
You probably dont want to be creating tables within the master db anyway.
When you load Access, chose 'Project (New Data)'. This should allow you to
create your own db, which you should be able to create tables in...
Cheers,
James Goodman
"Frank" <anonymous@.discussions.microsoft.com> wrote in message
news:4F160968-BBDD-4BEE-A13D-03ED349A3659@.microsoft.com...
> Hi Gurus,
> I've got a question when using Access Project with MSDE2000. I can
properly install MSDE and connect a Access Project with master database, but
I can't create table or modify table structure, is there any thing wrong?
> My os is XP, and Access 2000.
> Thanks in advance
>
Saturday, February 11, 2012
access deny the sa account
After install msde and create another user with system admin authority, is
it possible to disable the account sa to access the system for security
reason?
I have tried using sp_denylogin / sp_revokelogin but both failure. Thanks
in advance for any suggestion
hi Thomas
"Thomas Tsang" <thomast@.hkc.net> ha scritto nel messaggio
news:OdxjCVKwEHA.1308@.TK2MSFTNGP09.phx.gbl
> After install msde and create another user with system admin
> authority, is it possible to disable the account sa to access the
> system for security reason?
> I have tried using sp_denylogin / sp_revokelogin but both failure.
> Thanks in advance for any suggestion
sp_denylogin and sp_revokelogin only work with Windows NT users/groups and
not with SQL Server logins.
anyway, you can not disable "sa" login..
I know folks that renamed it directly in sysxlogins system table, but this
is not very polite :D , nor is supported..
the standard way to "disable" it is to assign it a random generated 128
chars password, so that no one knows it..
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
|||Thank for your information
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> bl
news:2upbhrF2b83gdU1@.uni-berlin.de g...
> hi Thomas
> "Thomas Tsang" <thomast@.hkc.net> ha scritto nel messaggio
> news:OdxjCVKwEHA.1308@.TK2MSFTNGP09.phx.gbl
> sp_denylogin and sp_revokelogin only work with Windows NT users/groups and
> not with SQL Server logins.
> anyway, you can not disable "sa" login..
> I know folks that renamed it directly in sysxlogins system table, but this
> is not very polite :D , nor is supported..
> the standard way to "disable" it is to assign it a random generated 128
> chars password, so that no one knows it..
> --
> 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
>
it possible to disable the account sa to access the system for security
reason?
I have tried using sp_denylogin / sp_revokelogin but both failure. Thanks
in advance for any suggestion
hi Thomas
"Thomas Tsang" <thomast@.hkc.net> ha scritto nel messaggio
news:OdxjCVKwEHA.1308@.TK2MSFTNGP09.phx.gbl
> After install msde and create another user with system admin
> authority, is it possible to disable the account sa to access the
> system for security reason?
> I have tried using sp_denylogin / sp_revokelogin but both failure.
> Thanks in advance for any suggestion
sp_denylogin and sp_revokelogin only work with Windows NT users/groups and
not with SQL Server logins.
anyway, you can not disable "sa" login..
I know folks that renamed it directly in sysxlogins system table, but this
is not very polite :D , nor is supported..
the standard way to "disable" it is to assign it a random generated 128
chars password, so that no one knows it..
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
|||Thank for your information
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> bl
news:2upbhrF2b83gdU1@.uni-berlin.de g...
> hi Thomas
> "Thomas Tsang" <thomast@.hkc.net> ha scritto nel messaggio
> news:OdxjCVKwEHA.1308@.TK2MSFTNGP09.phx.gbl
> sp_denylogin and sp_revokelogin only work with Windows NT users/groups and
> not with SQL Server logins.
> anyway, you can not disable "sa" login..
> I know folks that renamed it directly in sysxlogins system table, but this
> is not very polite :D , nor is supported..
> the standard way to "disable" it is to assign it a random generated 128
> chars password, so that no one knows it..
> --
> 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
>
Subscribe to:
Posts (Atom)