Can I impersonate a userid in sql server odbc connection to Sql Server 2000?

My client gave me a domain/userid which I use with terminal server and mapped network drives to do work for them. However, I'd like to set up odbc access from my client pc (which is not on their domain) to their database for testing. It seems like you only have 2 choices - trusted authentication or sql authentication. Is there any way to use trusted authentication but change the userid? This would be similar to the map network drive "connect using a different user id" function.

I'm connecting to a Win2003 server running SQL Server 2000 from a WinXP PC.

Not realy, if you are using trusted connections you need to have a valid username and password that is allowed on the sql server. Is there a way that you could get the DBA to add your workstation\username to the database, then you should be able to pass your details... The other option would be to get another user set up that you could terminal serve in with and test with that.

|||Thanks for the answer. I do use terminal server but I have a problem in that once i minimize the screen or close it and come back in, my access database that is running minimizes and won't come back. So I thought I'd use odbc from my workstation to check on the status of the programs. I'll pursue having them add my workstation and userid as a trusted userid on that server.

Can I have different SQL clients co-exist?

Can I have both SQL 6.5 client (Enterprise Manager, ISQL_w etc) and SQL 2000
(Enterprise Manager, SQL Analyzer) installed on the same machine?
Ippy wrote:
> Can I have both SQL 6.5 client (Enterprise Manager, ISQL_w etc) and
> SQL 2000 (Enterprise Manager, SQL Analyzer) installed on the same
> machine?
I don't believe that is supported. You can do what you want using a tool
like VirtualPC from Microsoft or VMWare. That is, you can run a virtual
PC and install whatever you want and have the virtual session connect
with your main PC or other PCs on your network.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Hi
It is possible and usable, but due to the fact that SQL Server 6.5 is no
longer supported by Microsoft, and Service Packs and hotfixes for SQL Server
2000 you may apply might break it.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ippy" <Ippy@.discussions.microsoft.com> wrote in message
news:857A42FB-1367-4278-A23E-4219812D495E@.microsoft.com...
> Can I have both SQL 6.5 client (Enterprise Manager, ISQL_w etc) and SQL
> 2000
> (Enterprise Manager, SQL Analyzer) installed on the same machine?
|||Hi,
Yes, you install SQL 6.5 and SQL 2000 in same machine. As well as you can
execute ISQLW and Enterprise manager of both versions in parallel.
Note:
If you are installing SQL 2000 client in a machine with SQL 7 client, the
SQL 2000 setup program will overwrite your SQL 7 client tools.
But SQL 2000 client tools support all SQL 7 activities.
Thanks
Hari
SQL Server MVP
"Ippy" <Ippy@.discussions.microsoft.com> wrote in message
news:857A42FB-1367-4278-A23E-4219812D495E@.microsoft.com...
> Can I have both SQL 6.5 client (Enterprise Manager, ISQL_w etc) and SQL
> 2000
> (Enterprise Manager, SQL Analyzer) installed on the same machine?
sql

Can I Deploy a report to a client who doesn't have SQL server license.

How can I Deploy a report with my visual Studio.Net application to a company
who doesn't have SQL server license?
I plan to use SQL Server 2005 Express.SQL Server Express does not yet have support for this. Supposedly Q1. Then
the data needs to reside locally as well.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> How can I Deploy a report with my visual Studio.Net application to a
> company who doesn't have SQL server license?
> I plan to use SQL Server 2005 Express.
>|||VS2005 provide a report viewer control which allow you to render reports.
does your application is web or windows based?
"Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> How can I Deploy a report with my visual Studio.Net application to a
> company who doesn't have SQL server license?
> I plan to use SQL Server 2005 Express.
>|||Hi Roberto,
As Bruce mentioned, the SQL Server reporting service is not available for
EXPRESS edition so far. Also, what's your application's detailed structure,
does it require a local SQL Server instance? If it is just a client
application which can consume reporting service reports through those
remote accessible programming interfaces, we can consider separate the
application from the backend SQL Server database... Thus, there need a
certain DataBase server which have SQL Server 2005 instance installed
already...
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "Jéj? <willgart@.BBBhotmailAAA.com>
| References: <#uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl>
| Subject: Re: Can I Deploy a report to a client who doesn't have SQL
server license.
| Date: Thu, 26 Jan 2006 21:35:45 -0500
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Response
| Message-ID: <emzDhpuIGHA.424@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: modemcable008.41-80-70.mc.videotron.ca 70.80.41.8
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67651
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| VS2005 provide a report viewer control which allow you to render reports.
| does your application is web or windows based?
|
| "Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
| news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
| > How can I Deploy a report with my visual Studio.Net application to a
| > company who doesn't have SQL server license?
| >
| > I plan to use SQL Server 2005 Express.
| >
|
|
||||RDLC reports doesn't required any server.
its standalone reports generated on the client side, not the server side.
Also, I think that the report control can render RDL reports without using a
reportserver.
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:TUqDfawIGHA.1236@.TK2MSFTNGXA02.phx.gbl...
> Hi Roberto,
> As Bruce mentioned, the SQL Server reporting service is not available for
> EXPRESS edition so far. Also, what's your application's detailed
> structure,
> does it require a local SQL Server instance? If it is just a client
> application which can consume reporting service reports through those
> remote accessible programming interfaces, we can consider separate the
> application from the backend SQL Server database... Thus, there need a
> certain DataBase server which have SQL Server 2005 instance installed
> already...
> Regards,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>
> --
> | From: "Jéj? <willgart@.BBBhotmailAAA.com>
> | References: <#uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl>
> | Subject: Re: Can I Deploy a report to a client who doesn't have SQL
> server license.
> | Date: Thu, 26 Jan 2006 21:35:45 -0500
> | Lines: 12
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | X-RFC2646: Format=Flowed; Response
> | Message-ID: <emzDhpuIGHA.424@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: modemcable008.41-80-70.mc.videotron.ca 70.80.41.8
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:67651
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | VS2005 provide a report viewer control which allow you to render
> reports.
> | does your application is web or windows based?
> |
> | "Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
> | news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> | > How can I Deploy a report with my visual Studio.Net application to a
> | > company who doesn't have SQL server license?
> | >
> | > I plan to use SQL Server 2005 Express.
> | >
> |
> |
> |
>

Can I Copy Structure from One Location (server) to Another (server)

hi all,

i am develpoing an application, and using SQL 2000. i have some of the client. and my devloping as well as the database modifiction is under construction... and now i want to copy the newly added feature such as new table, view as well as some new columns of existing table.. etc.. to Client server..

is there any easier way to copy structure to client side without affecting its data.

Tejas Kishanwala

Easier way ? the answer is NO.......... In such scenario , if u have a systamatic method then it is very easier to handle multiple development server. Before applying any change to master Developemnt server u create a script for the particular modification and apply that in master and distribute the script to others also. Otherwise there are third party tool available for it. u can try that.

Madhu

|||Hi,
thanx for reply.

pls. give me the name of some of the third party tool............

Tejas|||

check this site: http://www.red-gate.com/

also google for free sql tools

Madhu

|||

Be aware that also the visual Studio for Database professional has a funcationality to do this. You can compare two database for schema or data differences and create alter / update scripts to change the target database and to keep them in sync. As the tool is integrated within visual Studio and it has some other interesting features for development I would suggest you to check this out.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Can I attach to my 2005 Express DB using the 2005 Mgt Studio (NOT EXPRESS) client?

I have a 2005 Express DB I wish to attach to using the 2005 Mgt Studio Client (Not the express version, but the full blown 2005 Mgt Studio Client from the SQL 2005 Standard Edition Install disk). Can this be done, or can I only use the 2005 Mgt Studio Express Edition Client?

Thanks in advance.
M. Scott Blalock

You can use either one.

Buck Woody

Can I assign rowguid from the client code instead of using default newid()?

Do I have to use default newid() for the rowguid? I would prefer to pass a
sequential GUID from the client code instead.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server-replication/200701/1
Or can I at least use newsequentialid() instead of newid() as the ROWGUID
default?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server-replication/200701/1
|||Alex,
Yes,
CREATE TABLE dbo.Table1
(
test uniqueidentifier NOT NULL ROWGUIDCOL
) ON [PRIMARY]
ALTER TABLE dbo.Table1 ADD CONSTRAINT
DF_Table1_test DEFAULT (newid()) FOR test
-- Bill
"Alex via droptable.com" <no@.spam.pls> wrote in message
news:6bd9f60658969@.uwe...
> Or can I at least use newsequentialid() instead of newid() as the ROWGUID
> default?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server-replication/200701/1
>
|||Thank you for your response. It seems your code is still using newid(), but
anyway it is not what I was asking. The MS documentation says that one can
create replication ROWGUID column manually as long as it have the following
characteristics:
* The data type as UNIQUEIDENTIFIER.
* The default as NEWID().
* The ROWGUIDCOL property.
* A unique index on the column.
My questions are:
1. Can I use newsequentialid() instead of newid() ?
2. Can I supply GUID from my client code instead of using this default value?
I am interested in transactional replication model with updating subscribers.
AlterEgo wrote:[vbcol=seagreen]
>Alex,
>Yes,
>CREATE TABLE dbo.Table1
> (
> test uniqueidentifier NOT NULL ROWGUIDCOL
> ) ON [PRIMARY]
>ALTER TABLE dbo.Table1 ADD CONSTRAINT
> DF_Table1_test DEFAULT (newid()) FOR test
>-- Bill
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server-replication/200701/1

Can I access SQL Server from client Linux?

Can I access SQL Server from client Linux?
And Any functions in Postgre are in SqlServer?By access to you mean that you want to code a program to connect to and
work with SQL Server? If so, then yes...If you're on Linux you'll have
to use ODBC or JDBC (if you have the JDBC driver for SQL Server
installed on the machine hosting SQL Server) and the appropriate
connection string (which I don't remember right now, sorry, but it
should be somewhere if you Google it or probably someone in the
newsgroup remembers it) in your program.
If you want something that you can use to manager/administrate your SQL
Server from Linix (like Enterprise Manager/Management Studio as you
would have on Windows) then sorry but I am not aware of any tools out
there for this purpose. Maybe someone else can help on this?
As for Postgre functions in SQL Server. Well, I'm not sure...All the
standard SQL you know should cross over fine but I would suggest taking
a bit of time to learn Transact-SQL and what it has to offer (or at
least have a reference handy). Thankfully, SQL Server Books Online can
be accessed from the web on:
SQL Server 2005: http://msdn2.microsoft.com/en-us/library/ms130214.aspx
SQL Server 2000:
http://msdn.microsoft.com/library/d...
ap1.asp
Hope that helps a little but sorry if it didn't

Can connect with IP number but not with machine name

Running MSDE2000A named instance on an XP Pro machine as part of a domain
(W2003 server) , connecting from a client: with a connection
'machinename\instancename' i get no connection ('server not found or accss
denied'); however with the same setup and a connection
'172.0.30.14\instancename' everything works as expected. I can use an alias
for the IP number and that works but an alias for the machine name does not.
With a DHCP server, the IP address isn't permanent so how do I configure the
connection in my application?
More info - Colleagues have suggested that this is a simple DNS problem. But
I can connect to the machine using the DNS names in other apps (e.g. 'my
network Places') - it's just SQL that won't connect.
"quilkin" wrote:

> Running MSDE2000A named instance on an XP Pro machine as part of a domain
> (W2003 server) , connecting from a client: with a connection
> 'machinename\instancename' i get no connection ('server not found or accss
> denied'); however with the same setup and a connection
> '172.0.30.14\instancename' everything works as expected. I can use an alias
> for the IP number and that works but an alias for the machine name does not.
> With a DHCP server, the IP address isn't permanent so how do I configure the
> connection in my application?

Can connect with IP number but not with machine name

Running MSDE2000A named instance on an XP Pro machine as part of a domain
(W2003 server) , connecting from a client: with a connection
'machinename\instancename' i get no connection ('server not found or accss
denied'); however with the same setup and a connection
'172.0.30.14\instancename' everything works as expected. I can use an alias
for the IP number and that works but an alias for the machine name does not.
With a DHCP server, the IP address isn't permanent so how do I configure the
connection in my application?More info - Colleagues have suggested that this is a simple DNS problem. But
I can connect to the machine using the DNS names in other apps (e.g. 'my
network Places') - it's just SQL that won't connect.
"quilkin" wrote:

> Running MSDE2000A named instance on an XP Pro machine as part of a domain
> (W2003 server) , connecting from a client: with a connection
> 'machinename\instancename' i get no connection ('server not found or accss
> denied'); however with the same setup and a connection
> '172.0.30.14\instancename' everything works as expected. I can use an alia
s
> for the IP number and that works but an alias for the machine name does no
t.
> With a DHCP server, the IP address isn't permanent so how do I configure t
he
> connection in my application?

Can connect with IP number but not with machine name

Running MSDE2000A named instance on an XP Pro machine as part of a domain
(W2003 server) , connecting from a client: with a connection
'machinename\instancename' i get no connection ('server not found or accss
denied'); however with the same setup and a connection
'172.0.30.14\instancename' everything works as expected. I can use an alias
for the IP number and that works but an alias for the machine name does not.
With a DHCP server, the IP address isn't permanent so how do I configure the
connection in my application?More info - Colleagues have suggested that this is a simple DNS problem. But
I can connect to the machine using the DNS names in other apps (e.g. 'my
network Places') - it's just SQL that won't connect.
"quilkin" wrote:
> Running MSDE2000A named instance on an XP Pro machine as part of a domain
> (W2003 server) , connecting from a client: with a connection
> 'machinename\instancename' i get no connection ('server not found or accss
> denied'); however with the same setup and a connection
> '172.0.30.14\instancename' everything works as expected. I can use an alias
> for the IP number and that works but an alias for the machine name does not.
> With a DHCP server, the IP address isn't permanent so how do I configure the
> connection in my application?

Can connect to only One instance from another computer

We can only connect to only 1 instance, either the default localhost or the
named instance from another client.
For example on my computer the other client can connect to the localhost and
the other instance name such as server\instancenames cannot be connected. On
the other computer that does not have the default instance, the client can
only connect to one instance such as server\instancename.
The error message is the same as when sql cannot connect.
Mike
What version, edition of SQL Server? What is the exact error
message? What are you using to try to connect - application,
SQL Tools, DSN? Did you check for what instances are
running? The clients that can't connect to a named instance
- did you check their MDAC versions? Can you connect to
default and named instances when on the box where the
instances are running?
-Sue
On Thu, 23 Mar 2006 07:00:29 -0800, Mike9900
<Mike9900@.discussions.microsoft.com> wrote:

>We can only connect to only 1 instance, either the default localhost or the
>named instance from another client.
>For example on my computer the other client can connect to the localhost and
>the other instance name such as server\instancenames cannot be connected. On
>the other computer that does not have the default instance, the client can
>only connect to one instance such as server\instancename.
>The error message is the same as when sql cannot connect.

Can connect to only One instance from another computer

We can only connect to only 1 instance, either the default localhost or the
named instance from another client.
For example on my computer the other client can connect to the localhost and
the other instance name such as server\instancenames cannot be connected. On
the other computer that does not have the default instance, the client can
only connect to one instance such as server\instancename.
The error message is the same as when sql cannot connect.
MikeWhat version, edition of SQL Server? What is the exact error
message? What are you using to try to connect - application,
SQL Tools, DSN? Did you check for what instances are
running? The clients that can't connect to a named instance
- did you check their MDAC versions? Can you connect to
default and named instances when on the box where the
instances are running?
-Sue
On Thu, 23 Mar 2006 07:00:29 -0800, Mike9900
<Mike9900@.discussions.microsoft.com> wrote:

>We can only connect to only 1 instance, either the default localhost or the
>named instance from another client.
>For example on my computer the other client can connect to the localhost an
d
>the other instance name such as server\instancenames cannot be connected. O
n
>the other computer that does not have the default instance, the client can
>only connect to one instance such as server\instancename.
>The error message is the same as when sql cannot connect.

can connect to all servers but one on certain box

I have an issue where users can't connect to a server - Server A - from a pa
rticular client computer - Box B. They can connect to other servers from Box
B - even servers in the same cluster as Server A. On other client machines
the same users can connect
to all servers - including Server A. They are using Windows authorization. I
s there any setting that might need to be changed either in Windows or SQL S
erver on either Server A or Box B that might correct this situation?Sounds like you want to check Client Network Utility and Server Network
Utility on the involved machines.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"hawthorne" <anonymous@.discussions.microsoft.com> wrote in message
news:A3F01255-54EF-4F09-A8AD-0CBA21C6D04B@.microsoft.com...
> I have an issue where users can't connect to a server - Server A - from a
particular client computer - Box B. They can connect to other servers from
Box B - even servers in the same cluster as Server A. On other client
machines the same users can connect to all servers - including Server A.
They are using Windows authorization. Is there any setting that might need
to be changed either in Windows or SQL Server on either Server A or Box B
that might correct this situation?|||Can you PING Server A from Box B ?

Can anyone Help me ?

Hi all,
I am very new to SQL Server 2000
my problem is that to connect to sql server from a client computer
first i have to log in to the system in which the sql server is
installed
is it possible that i dont have to login to the computer
so that i just open the query analyzer and just login with the sql
server user account i dont want to give the login & the password of the
windows
can any one help me in this
is this possible
sam
Let me try to understand your question. You seem to be saying that to be
able to get access to SQL server you have to access the machine SQL Server
runs on (ie by standing beside it, or by remote control software) and then
get access?
If so, you should be able to access that SQL Server remotely via Query
Analyzer as long as your Windows Account has a login to that SQL Server and
you are using Windows Authentication in Query Analyzer.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegr oups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>
|||Hello Sam,
To do this; First of all you should be in the same domain or trusted doamin
the sql server exists. After that you will have to ask the SQL Server DBA
to add your windows login into sql server. After this you should be able to
login to sql server using the windows authentication.
Thanks
Hari
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegr oups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>
|||Thanks for your consideration
it helped me a lot
Hari Prasad wrote:
[vbcol=seagreen]
> Hello Sam,
> To do this; First of all you should be in the same domain or trusted doamin
> the sql server exists. After that you will have to ask the SQL Server DBA
> to add your windows login into sql server. After this you should be able to
> login to sql server using the windows authentication.
> Thanks
> Hari
>
> "sam" <sameersrivastava2k@.gmail.com> wrote in message
> news:1168268905.771075.208620@.s34g2000cwa.googlegr oups.com...

Can anyone Help me ?

Hi all,
I am very new to SQL Server 2000
my problem is that to connect to sql server from a client computer
first i have to log in to the system in which the sql server is
installed
is it possible that i dont have to login to the computer
so that i just open the query analyzer and just login with the sql
server user account i dont want to give the login & the password of the
windows
can any one help me in this
is this possible
samLet me try to understand your question. You seem to be saying that to be
able to get access to SQL server you have to access the machine SQL Server
runs on (ie by standing beside it, or by remote control software) and then
get access?
If so, you should be able to access that SQL Server remotely via Query
Analyzer as long as your Windows Account has a login to that SQL Server and
you are using Windows Authentication in Query Analyzer.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Hello Sam,
To do this; First of all you should be in the same domain or trusted doamin
the sql server exists. After that you will have to ask the SQL Server DBA
to add your windows login into sql server. After this you should be able to
login to sql server using the windows authentication.
Thanks
Hari
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Thanks for your consideration
it helped me a lot
Hari Prasad wrote:
> Hello Sam,
> To do this; First of all you should be in the same domain or trusted doamin
> the sql server exists. After that you will have to ask the SQL Server DBA
> to add your windows login into sql server. After this you should be able to
> login to sql server using the windows authentication.
> Thanks
> Hari
>
> "sam" <sameersrivastava2k@.gmail.com> wrote in message
> news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> > Hi all,
> >
> > I am very new to SQL Server 2000
> > my problem is that to connect to sql server from a client computer
> > first i have to log in to the system in which the sql server is
> > installed
> > is it possible that i dont have to login to the computer
> > so that i just open the query analyzer and just login with the sql
> > server user account i dont want to give the login & the password of the
> > windows
> >
> >
> > can any one help me in this
> > is this possible
> >
> > sam
> >

Can anyone Help me ?

Hi all,
I am very new to SQL Server 2000
my problem is that to connect to sql server from a client computer
first i have to log in to the system in which the sql server is
installed
is it possible that i dont have to login to the computer
so that i just open the query analyzer and just login with the sql
server user account i dont want to give the login & the password of the
windows
can any one help me in this
is this possible
samLet me try to understand your question. You seem to be saying that to be
able to get access to SQL server you have to access the machine SQL Server
runs on (ie by standing beside it, or by remote control software) and then
get access?
If so, you should be able to access that SQL Server remotely via Query
Analyzer as long as your Windows Account has a login to that SQL Server and
you are using Windows Authentication in Query Analyzer.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Hello Sam,
To do this; First of all you should be in the same domain or trusted doamin
the sql server exists. After that you will have to ask the SQL Server DBA
to add your windows login into sql server. After this you should be able to
login to sql server using the windows authentication.
Thanks
Hari
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Thanks for your consideration
it helped me a lot
Hari Prasad wrote:
[vbcol=seagreen]
> Hello Sam,
> To do this; First of all you should be in the same domain or trusted doami
n
> the sql server exists. After that you will have to ask the SQL Server DBA
> to add your windows login into sql server. After this you should be able t
o
> login to sql server using the windows authentication.
> Thanks
> Hari
>
> "sam" <sameersrivastava2k@.gmail.com> wrote in message
> news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...

Can an SQL Server stored procedure write output to an excel formated file?

Hi,
To clarify the previous post.
I would like to write a stored procedure that a client can call. The
stored procedure will then output its result in an excel file.
Thanks,
chariaYou have things a little reversed. You should have the stored procedure
return the data. How you call the report will determine how it is rendered
(HTML, CSV, PDF, Excel etc). When integrating reports you can use URL
integration or webservices. Neither of which would be that easy from a
stored procedure.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<cpeters5@.gmail.com> wrote in message
news:1120582350.023702.281780@.g43g2000cwa.googlegroups.com...
> Hi,
> To clarify the previous post.
> I would like to write a stored procedure that a client can call. The
> stored procedure will then output its result in an excel file.
> Thanks,
> charia
>

Can a SQL Server database be access without having to log onto the server?

One of my client website got hack into and the web application that I created for them is disabled/block externally. Only internally within their business, they will be able to access it. The person that is maintaining the server say, a hacker went straight to the database without having to log onto the server. The person that is maintaining the server is blaming on my web application, which no one has access to view the page except internally within the client work location.

Is this is posibble if the server is secure?

Both scenarios are possible. Hacker might have gotten access to your database or got in through your app via SQL Injection attack. Do you use parameterized queries in your application?

|||

The queries is within the code-behind page, I didn't use stored procedured. But yes, it is paramaterize queries. How can a hacker be able to access a database without logging onto the database? Also, how a hacker be able to do an SQL Injection when all administrative webpage(within "admin" folder) is disable/block to all external users. Only the website is shown to external users and internal users is allow to view the administrative webpage. Sorry, if I didn't explain everything. For example, when accessing this: www.mywebsite.com/admin , it would show...

You are not authorized to view this page

The Web server you are attempting to reach has a list of IP addresses that are not allowed to access the Web site, and the IP address of your browsing computer is on this list.

---

Please try the following:

Contact the Web site administrator if you believe you should be able to view this directory or page.|||

Its very well possible. Do a google search for "SQL Injection attack".

Can a recursive query do this?

I am wondering if there is some type of recursive query to return the values I want from the following database.

Here is the setup:

The client builds reptile cages.

Each cage consists of aluminum framing, connectors to connect the aluminum frame, and panels to enclose the cages. In the example below, we are not leaving panels out to simplify things. We are also not concerned with the dimensions of the cage.

The PRODUCT table contains all parts in inventory. A finished cage is also considered a PRODUCT. The PRODUCT table is recursively joined to itself through the ASSEMBLY table.

PRODUCTS that consist of a number of PRODUCTS are called an ASSEMBLY. The ASSEMBLY table tracks what PRODUCTS are required for the ASSEMBLY.

Sample database can be downloaded from http://www.handlerassociates.com/cage_configurator.mdb

Here is a quick schema:

Table: PRODUCT
--------
PRODUCTID PK
PRODUCTNAME nVarChar(30)

Table: ASSEMBLY
--------
PRODUCTID PK (FK to PRODUCT.PRODUCTID)
COMPONENTID PK (FK to PRODUCT.PRODUCTID)
QTY INT

I can write a query that takes the PRODUCTID, and returns all

PRODUCT
=======
PRODUCTID PRODUCTNAME
--- ----
1 Cage Assembly - Solid Sides
2 Cage Assembly - Split Back
3 Cage Assembly - Split Sides
4 Cage Assembly - Split Top/Bottom
5 Cage Assembly - Split Back and Sides
6 Cage Assembly - Split Back and Top/Bottom
7 Cage Assembly - Split Back and Sides and Top/Bottom
8 33S - Aluminum Divider
9 33C - Aluminum Frame
10 T3C - Door Frame
11 Connector Kit
12 Connector Socket
13 Connector Screws

ASSEMBLY
=========
PRODUCTID COMPONENT QTY
--- --- --
1 9 8
1 10 4
1 11 1
2 1 1
2 8 1
3 1 1
3 8 1
4 1 1
4 8 1
5 1 1
5 8 2
6 1 1
6 8 2
7 1 1
7 8 3
11 12 8
11 13 8

I need a query that will give me all parts for each PRODUCT.

Example: I want all parts for the PRODUCT "Cage Assembly - Split Back"

The results would be:

PRODUCTID PRODUCTNAME
--- ----
2 Cage Assembly - Split Back
1 Cage Assemble - Solid Back
9 33C - Aluminum Frame
10 T3C - Door Frame
11 Connector Kit
8 33S - Aluminum Divider
12 Connector Socket
13 Connector Screws

Is it possible to write such a query or stored procedure?http://www.dbforums.com/t1080526.html|||in a specific case, yes, if you know in advance how many levels down the hierarchy of assemblies/parts you need to go, you would write a left outer join query with as many joins as the maximum number levels you need to traverse to find all component parts for the given part

in the general case, where this number of levels is not known in advance, no, you can't write a query for this

however, you could write a stored proc, but note that the stored proc would be running a query inside a loop and building up its results in a temp table|||Here is a solution that uses a UDF. I thought it was quite slick.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=4&messageid=152361|||yeah, that's what i suggested -- a query inside a loop that builds a temp table

:) :) :)

Can a clustered SQL 2000 installation run without DNS

A client of ours wants to run a clustered instance of SQL and not have it
dependent on name resolution for anything.
Since it appears that SQL is heavily dependent on AD and DNS for the virtual
server piece, does this dependancy constitute a single point of failure?
You will need DNS and AD for installing a SQL Server cluster or adding nodes
to it.
The nodes themselves don't necessarily need an active DC or DNS. In fact you
should enter the node, and cluster name in the host file to reduce the
amount of time a node requires to go online.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
news:368FFF28-CD47-4F92-A2D8-0FA72DEC1897@.microsoft.com...
> A client of ours wants to run a clustered instance of SQL and not have it
> dependent on name resolution for anything.
> Since it appears that SQL is heavily dependent on AD and DNS for the
virtual
> server piece, does this dependancy constitute a single point of failure?
>
|||Hilary, thanks for the validation. I know that AD and DNS is required, I just
am having problems convincing the client that they are required. I have
pointed out multiple articles in SQL books online, and TechNet/Support items
that also say the same thing.
Must have assumptions are not a satisfactory answer for this client. They
need to see it it writing that it must have explicitly AD/DNS.
Brian
"Hilary Cotter" wrote:

> You will need DNS and AD for installing a SQL Server cluster or adding nodes
> to it.
> The nodes themselves don't necessarily need an active DC or DNS. In fact you
> should enter the node, and cluster name in the host file to reduce the
> amount of time a node requires to go online.
>
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
> news:368FFF28-CD47-4F92-A2D8-0FA72DEC1897@.microsoft.com...
> virtual
>
>
|||I'd try to run cluster administrator to create a new cluster on a standalone
win2003 and take screen shots of it failing because it can't register the
cluster name in AD, or the IP address for the cluster in DNS.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
news:30241601-0AD5-4673-8102-48FEC2C932DE@.microsoft.com...
> Hilary, thanks for the validation. I know that AD and DNS is required, I
just
> am having problems convincing the client that they are required. I have
> pointed out multiple articles in SQL books online, and TechNet/Support
items[vbcol=seagreen]
> that also say the same thing.
> Must have assumptions are not a satisfactory answer for this client. They
> need to see it it writing that it must have explicitly AD/DNS.
> Brian
> "Hilary Cotter" wrote:
nodes[vbcol=seagreen]
you[vbcol=seagreen]
it[vbcol=seagreen]
failure?[vbcol=seagreen]
|||Hillary, here is the kicker for you. I don't know how they did it, however
they got the cluster and sql to run without the domain controllers/dns
servers. I will be heading over there in a little while to figure out what
they did.
Either way I know it is not a supported configuration by Microsoft, and I
cannot guarantee that it will not fail completely at some point and bite them
in the fanny.
Brian
"Hilary Cotter" wrote:

> I'd try to run cluster administrator to create a new cluster on a standalone
> win2003 and take screen shots of it failing because it can't register the
> cluster name in AD, or the IP address for the cluster in DNS.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
> news:30241601-0AD5-4673-8102-48FEC2C932DE@.microsoft.com...
> just
> items
> nodes
> you
> it
> failure?
>
>
|||Hilary, the following items were changed on both nodes of the cluster and
allows the resources to function correctly without AD/DNS.
MSSQLSERVER service to use LocalSystem Account, Interact with Desktop
unchecked.
SQLSERVERAGENT service to use LocalSystem Account, Interact with Desktop
unchecked.
Cluster Service to use local user account which has admin rights. Use same
account and password for both computers.
Following items added to lmhosts file;
10.50.32.34 NOCTMDS-DBTSQL #PRE //SQL Server Virtual IP
10.50.32.35 NOCTMDS-DBTEST #PRE //Microsoft Cluster Server
Virtual IP
DNS servers removed from TCP/IP Properties.
Enable NetBIOS over TCP/IP.
Only other change that was made is to /flushdns from both computers. Both
AD/DNS servers are turned off.
Cluster failover occurs normally.
First question is why does this work?
Is this a supported configuration by Microsoft, or does this go against
“Best Practices” for any specific reason?
If not supported by Microsoft, what is the down side to running in this
manner, and what problems could be expected by not using a Domain\Username
account for the services?
Any white papers, tech notes, releasable internal documents that specify it
must be done one way or the other (AD/DNS or Not needed) would be greatly
appreciated.
"Brian Cook" wrote:
[vbcol=seagreen]
> Hillary, here is the kicker for you. I don't know how they did it, however
> they got the cluster and sql to run without the domain controllers/dns
> servers. I will be heading over there in a little while to figure out what
> they did.
> Either way I know it is not a supported configuration by Microsoft, and I
> cannot guarantee that it will not fail completely at some point and bite them
> in the fanny.
> Brian
> "Hilary Cotter" wrote:
|||What version of the OS are we talking about 2000 or 2003?
2003 does seem to require AD and DNS to be live when creating the cluster.
It does appear that somehow they have managed to create a cluster without an
active DNS or AD. I don't believe Microsoft will support this configuration.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
news:B2143F93-C7C2-427E-9F54-970EB2117B7D@.microsoft.com...
> Hilary, the following items were changed on both nodes of the cluster and
> allows the resources to function correctly without AD/DNS.
> MSSQLSERVER service to use LocalSystem Account, Interact with Desktop
> unchecked.
> SQLSERVERAGENT service to use LocalSystem Account, Interact with Desktop
> unchecked.
> Cluster Service to use local user account which has admin rights. Use same
> account and password for both computers.
> Following items added to lmhosts file;
> 10.50.32.34 NOCTMDS-DBTSQL #PRE //SQL Server Virtual IP
> 10.50.32.35 NOCTMDS-DBTEST #PRE //Microsoft Cluster Server
> Virtual IP
> DNS servers removed from TCP/IP Properties.
> Enable NetBIOS over TCP/IP.
> Only other change that was made is to /flushdns from both computers. Both
> AD/DNS servers are turned off.
> Cluster failover occurs normally.
> First question is why does this work?
> Is this a supported configuration by Microsoft, or does this go against
> "Best Practices" for any specific reason?
> If not supported by Microsoft, what is the down side to running in this
> manner, and what problems could be expected by not using a Domain\Username
> account for the services?
> Any white papers, tech notes, releasable internal documents that specify
it[vbcol=seagreen]
> must be done one way or the other (AD/DNS or Not needed) would be greatly
> appreciated.
>
> "Brian Cook" wrote:
however[vbcol=seagreen]
what[vbcol=seagreen]
I[vbcol=seagreen]
them[vbcol=seagreen]
standalone[vbcol=seagreen]
the[vbcol=seagreen]
required, I[vbcol=seagreen]
have[vbcol=seagreen]
TechNet/Support[vbcol=seagreen]
They[vbcol=seagreen]
adding[vbcol=seagreen]
In fact[vbcol=seagreen]
the[vbcol=seagreen]
message[vbcol=seagreen]
not have[vbcol=seagreen]
the[vbcol=seagreen]
|||Hilary, this is a two node W2K3 installation. We have replicated it in our
lab and it is working. I am opening a case with Microsoft today to confirm my
suspicions that it is not a support configuration, and also see if there are
any down sides to this configuration.
My concern is that since we are developing an application that uses SQL, yet
does not rely on the "name" of the db server, and at some point down the
road, if the cluster fails, and stops working will it be because of the way
the system is configured or something else as it is not configured as it was
designed to be used, and our company end up with the liability for the
failure.
Brian
"Hilary Cotter" wrote:

> What version of the OS are we talking about 2000 or 2003?
> 2003 does seem to require AD and DNS to be live when creating the cluster.
> It does appear that somehow they have managed to create a cluster without an
> active DNS or AD. I don't believe Microsoft will support this configuration.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Brian Cook" <BrianCook@.discussions.microsoft.com> wrote in message
> news:B2143F93-C7C2-427E-9F54-970EB2117B7D@.microsoft.com...
> it
> however
> what
> I
> them
> standalone
> the
> required, I
> have
> TechNet/Support
> They
> adding
> In fact
> the
> message
> not have
> the
>
>