BlankHello,
I'm using Query Analyzer and I'm trying to select from a table on another database...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a different server?
Thanks for any help,
Matt
BlankTry specifying the object owner:
Select *
FROM DB1.dbo.Test1
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questions
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:%23IGqqbIjFHA.3704@.TK2MSFTNGP10.phx.gbl...
Hello,
I'm using Query Analyzer and I'm trying to select from a table on another database...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a different server?
Thanks for any help,
Matt
|||BlankThanks for the help Kevin,
I actually tried that with no luck whatsoever..... Thanks for the insight, I appreciate the feedback.
Matt
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message news:%23r5pqsIjFHA.3300@.TK2MSFTNGP15.phx.gbl...
Try specifying the object owner:
Select *
FROM DB1.dbo.Test1
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questions
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:%23IGqqbIjFHA.3704@.TK2MSFTNGP10.phx.gbl...
Hello,
I'm using Query Analyzer and I'm trying to select from a table on another database...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a different server?
Thanks for any help,
Matt
|||BlankAny Other Suggestions?......
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message news:%23r5pqsIjFHA.3300@.TK2MSFTNGP15.phx.gbl...
Try specifying the object owner:
Select *
FROM DB1.dbo.Test1
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questions
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:%23IGqqbIjFHA.3704@.TK2MSFTNGP10.phx.gbl...
Hello,
I'm using Query Analyzer and I'm trying to select from a table on another database...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a different server?
Thanks for any help,
Matt
|||BlankNone. I pasted your code into my QA and it parses correctly (as I assumed). When I ran it, I got the expected:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'DB1..Test1'.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questions
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:OgBOO3IjFHA.1148@.TK2MSFTNGP12.phx.gbl...
Any Other Suggestions?......
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message news:%23r5pqsIjFHA.3300@.TK2MSFTNGP15.phx.gbl...
Try specifying the object owner:
Select *
FROM DB1.dbo.Test1
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questions
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:%23IGqqbIjFHA.3704@.TK2MSFTNGP10.phx.gbl...
Hello,
I'm using Query Analyzer and I'm trying to select from a table on another database...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a different server?
Thanks for any help,
Matt
|||If your database name were not valid (or table name, for that matter), the
error you should get is:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'DB1..Test1'.
Therefore, that leads me to believe that there is more to your query than
you posted.
|||Now you post a different error message than you posted earlier. "Invalid object name" simply states
that there is no table or view named "Test1" inside the DB1 database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23fCPs7IjFHA.2156@.TK2MSFTNGP14.phx.gbl...
BlankNone. I pasted your code into my QA and it parses correctly (as I assumed). When I ran it, I
got the expected:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'DB1..Test1'.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questions
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:OgBOO3IjFHA.1148@.TK2MSFTNGP12.phx.gbl...
Any Other Suggestions?......
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23r5pqsIjFHA.3300@.TK2MSFTNGP15.phx.gbl...
Try specifying the object owner:
Select *
FROM DB1.dbo.Test1
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questions
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message
news:%23IGqqbIjFHA.3704@.TK2MSFTNGP10.phx.gbl...
Hello,
I'm using Query Analyzer and I'm trying to select from a table on another database...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a different server?
Thanks for any help,
Matt
|||Yes there was... My database name was a number.
I had to enclose in quotations...
Thanks for your help
"Scott Morris" <bogus@.bogus.com> wrote in message
news:%23Xs4C9IjFHA.3012@.TK2MSFTNGP12.phx.gbl...
> If your database name were not valid (or table name, for that matter), the
> error you should get is:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'DB1..Test1'.
> Therefore, that leads me to believe that there is more to your query than
> you posted.
>
|||That was me, not the OP...;-)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e9vm%23DJjFHA.3704@.TK2MSFTNGP10.phx.gbl...
> Now you post a different error message than you posted earlier. "Invalid
> object name" simply states that there is no table or view named "Test1"
> inside the DB1 database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:%23fCPs7IjFHA.2156@.TK2MSFTNGP14.phx.gbl...
> BlankNone. I pasted your code into my QA and it parses correctly (as I
> assumed). When I ran it, I got the expected:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'DB1..Test1'.
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Matthew Beirn" <mbeirn@.ssimed.com> wrote in message
> news:OgBOO3IjFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Any Other Suggestions?......
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:%23r5pqsIjFHA.3300@.TK2MSFTNGP15.phx.gbl...
> Try specifying the object owner:
> Select *
> FROM DB1.dbo.Test1
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Matthew Beirn" <mbeirn@.ssimed.com> wrote in message
> news:%23IGqqbIjFHA.3704@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I'm using Query Analyzer and I'm trying to select from a table on
> another database...
> i.e..I'm on DB2 in query analyzer and this is what my query looks
> like
> Select *
> FROM DB1..Test1
> But I'm getting an error
> Server: Msg 170, Level 15, State 1, Line 2
> Line 2: Incorrect syntax near 'DB1.'.
> This query worked on my local machine... Could it be a set-up issue
> on a different server?
> Thanks for any help,
> Matt
|||Ahh, sloppy me... :-)
Thanks for catching that, Kevin.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23YgOUYJjFHA.1044@.tk2msftngp13.phx.gbl...
> That was me, not the OP...;-)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your questions
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:e9vm%23DJjFHA.3704@.TK2MSFTNGP10.phx.gbl...
>
Showing posts with label analyzer. Show all posts
Showing posts with label analyzer. Show all posts
Sunday, March 25, 2012
Accessing Different Databases on Same Server with Dot Notation.
BlankHello,
I'm using Query Analyzer and I'm trying to select from a table on another da
tabase...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a d
ifferent server?
Thanks for any help,
MattBlankTry specifying the object owner:
Select *
FROM DB1.dbo.Test1
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questio
ns
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:%23IGqqbIjFHA.3704
@.TK2MSFTNGP10.phx.gbl...
Hello,
I'm using Query Analyzer and I'm trying to select from a table on another da
tabase...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a d
ifferent server?
Thanks for any help,
Matt|||BlankThanks for the help Kevin,
I actually tried that with no luck whatsoever..... Thanks for the insight,
I appreciate the feedback.
Matt
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message news:%23r
5pqsIjFHA.3300@.TK2MSFTNGP15.phx.gbl...
Try specifying the object owner:
Select *
FROM DB1.dbo.Test1
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questio
ns
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:%23IGqqbIjFHA.3704
@.TK2MSFTNGP10.phx.gbl...
Hello,
I'm using Query Analyzer and I'm trying to select from a table on another da
tabase...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a d
ifferent server?
Thanks for any help,
Matt|||BlankAny Other Suggestions?......
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message news:%23r
5pqsIjFHA.3300@.TK2MSFTNGP15.phx.gbl...
Try specifying the object owner:
Select *
FROM DB1.dbo.Test1
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questio
ns
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:%23IGqqbIjFHA.3704
@.TK2MSFTNGP10.phx.gbl...
Hello,
I'm using Query Analyzer and I'm trying to select from a table on another da
tabase...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a d
ifferent server?
Thanks for any help,
Matt|||BlankNone. I pasted your code into my QA and it parses correctly (as I assu
med). When I ran it, I got the expected:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'DB1..Test1'.
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questio
ns
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:OgBOO3IjFHA.1148@.T
K2MSFTNGP12.phx.gbl...
Any Other Suggestions?......
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message news:%23r
5pqsIjFHA.3300@.TK2MSFTNGP15.phx.gbl...
Try specifying the object owner:
Select *
FROM DB1.dbo.Test1
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questio
ns
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:%23IGqqbIjFHA.3704
@.TK2MSFTNGP10.phx.gbl...
Hello,
I'm using Query Analyzer and I'm trying to select from a table on another da
tabase...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a d
ifferent server?
Thanks for any help,
Matt|||If your database name were not valid (or table name, for that matter), the
error you should get is:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'DB1..Test1'.
Therefore, that leads me to believe that there is more to your query than
you posted.|||Now you post a different error message than you posted earlier. "Invalid obj
ect name" simply states
that there is no table or view named "Test1" inside the DB1 database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23fCPs7IjFHA.2156@.TK2MSFTNGP14.phx.gbl...
BlankNone. I pasted your code into my QA and it parses correctly (as I assu
med). When I ran it, I
got the expected:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'DB1..Test1'.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questio
ns
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:OgBOO3IjFHA.1148@.T
K2MSFTNGP12.phx.gbl...
Any Other Suggestions?......
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23r5pqsIjFHA.3300@.TK2MSFTNGP15.phx.gbl...
Try specifying the object owner:
Select *
FROM DB1.dbo.Test1
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questio
ns
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message
news:%23IGqqbIjFHA.3704@.TK2MSFTNGP10.phx.gbl...
Hello,
I'm using Query Analyzer and I'm trying to select from a table on another da
tabase...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a d
ifferent server?
Thanks for any help,
Matt|||Yes there was... My database name was a number.
I had to enclose in quotations...
Thanks for your help
"Scott Morris" <bogus@.bogus.com> wrote in message
news:%23Xs4C9IjFHA.3012@.TK2MSFTNGP12.phx.gbl...
> If your database name were not valid (or table name, for that matter), the
> error you should get is:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'DB1..Test1'.
> Therefore, that leads me to believe that there is more to your query than
> you posted.
>|||That was me, not the OP...;-)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e9vm%23DJjFHA.3704@.TK2MSFTNGP10.phx.gbl...
> Now you post a different error message than you posted earlier. "Invalid
> object name" simply states that there is no table or view named "Test1"
> inside the DB1 database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:%23fCPs7IjFHA.2156@.TK2MSFTNGP14.phx.gbl...
> BlankNone. I pasted your code into my QA and it parses correctly (as I
> assumed). When I ran it, I got the expected:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'DB1..Test1'.
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Matthew Beirn" <mbeirn@.ssimed.com> wrote in message
> news:OgBOO3IjFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Any Other Suggestions?......
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:%23r5pqsIjFHA.3300@.TK2MSFTNGP15.phx.gbl...
> Try specifying the object owner:
> Select *
> FROM DB1.dbo.Test1
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Matthew Beirn" <mbeirn@.ssimed.com> wrote in message
> news:%23IGqqbIjFHA.3704@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I'm using Query Analyzer and I'm trying to select from a table on
> another database...
> i.e..I'm on DB2 in query analyzer and this is what my query looks
> like
> Select *
> FROM DB1..Test1
> But I'm getting an error
> Server: Msg 170, Level 15, State 1, Line 2
> Line 2: Incorrect syntax near 'DB1.'.
> This query worked on my local machine... Could it be a set-up issue
> on a different server?
> Thanks for any help,
> Matt|||Ahh, sloppy me... :-)
Thanks for catching that, Kevin.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23YgOUYJjFHA.1044@.tk2msftngp13.phx.gbl...
> That was me, not the OP...;-)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your quest
ions
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:e9vm%23DJjFHA.3704@.TK2MSFTNGP10.phx.gbl...
>
I'm using Query Analyzer and I'm trying to select from a table on another da
tabase...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a d
ifferent server?
Thanks for any help,
MattBlankTry specifying the object owner:
Select *
FROM DB1.dbo.Test1
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questio
ns
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:%23IGqqbIjFHA.3704
@.TK2MSFTNGP10.phx.gbl...
Hello,
I'm using Query Analyzer and I'm trying to select from a table on another da
tabase...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a d
ifferent server?
Thanks for any help,
Matt|||BlankThanks for the help Kevin,
I actually tried that with no luck whatsoever..... Thanks for the insight,
I appreciate the feedback.
Matt
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message news:%23r
5pqsIjFHA.3300@.TK2MSFTNGP15.phx.gbl...
Try specifying the object owner:
Select *
FROM DB1.dbo.Test1
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questio
ns
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:%23IGqqbIjFHA.3704
@.TK2MSFTNGP10.phx.gbl...
Hello,
I'm using Query Analyzer and I'm trying to select from a table on another da
tabase...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a d
ifferent server?
Thanks for any help,
Matt|||BlankAny Other Suggestions?......
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message news:%23r
5pqsIjFHA.3300@.TK2MSFTNGP15.phx.gbl...
Try specifying the object owner:
Select *
FROM DB1.dbo.Test1
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questio
ns
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:%23IGqqbIjFHA.3704
@.TK2MSFTNGP10.phx.gbl...
Hello,
I'm using Query Analyzer and I'm trying to select from a table on another da
tabase...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a d
ifferent server?
Thanks for any help,
Matt|||BlankNone. I pasted your code into my QA and it parses correctly (as I assu
med). When I ran it, I got the expected:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'DB1..Test1'.
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questio
ns
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:OgBOO3IjFHA.1148@.T
K2MSFTNGP12.phx.gbl...
Any Other Suggestions?......
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message news:%23r
5pqsIjFHA.3300@.TK2MSFTNGP15.phx.gbl...
Try specifying the object owner:
Select *
FROM DB1.dbo.Test1
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questio
ns
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:%23IGqqbIjFHA.3704
@.TK2MSFTNGP10.phx.gbl...
Hello,
I'm using Query Analyzer and I'm trying to select from a table on another da
tabase...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a d
ifferent server?
Thanks for any help,
Matt|||If your database name were not valid (or table name, for that matter), the
error you should get is:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'DB1..Test1'.
Therefore, that leads me to believe that there is more to your query than
you posted.|||Now you post a different error message than you posted earlier. "Invalid obj
ect name" simply states
that there is no table or view named "Test1" inside the DB1 database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23fCPs7IjFHA.2156@.TK2MSFTNGP14.phx.gbl...
BlankNone. I pasted your code into my QA and it parses correctly (as I assu
med). When I ran it, I
got the expected:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'DB1..Test1'.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questio
ns
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message news:OgBOO3IjFHA.1148@.T
K2MSFTNGP12.phx.gbl...
Any Other Suggestions?......
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23r5pqsIjFHA.3300@.TK2MSFTNGP15.phx.gbl...
Try specifying the object owner:
Select *
FROM DB1.dbo.Test1
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your questio
ns
"Matthew Beirn" <mbeirn@.ssimed.com> wrote in message
news:%23IGqqbIjFHA.3704@.TK2MSFTNGP10.phx.gbl...
Hello,
I'm using Query Analyzer and I'm trying to select from a table on another da
tabase...
i.e..I'm on DB2 in query analyzer and this is what my query looks like
Select *
FROM DB1..Test1
But I'm getting an error
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'DB1.'.
This query worked on my local machine... Could it be a set-up issue on a d
ifferent server?
Thanks for any help,
Matt|||Yes there was... My database name was a number.
I had to enclose in quotations...
Thanks for your help
"Scott Morris" <bogus@.bogus.com> wrote in message
news:%23Xs4C9IjFHA.3012@.TK2MSFTNGP12.phx.gbl...
> If your database name were not valid (or table name, for that matter), the
> error you should get is:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'DB1..Test1'.
> Therefore, that leads me to believe that there is more to your query than
> you posted.
>|||That was me, not the OP...;-)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e9vm%23DJjFHA.3704@.TK2MSFTNGP10.phx.gbl...
> Now you post a different error message than you posted earlier. "Invalid
> object name" simply states that there is no table or view named "Test1"
> inside the DB1 database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:%23fCPs7IjFHA.2156@.TK2MSFTNGP14.phx.gbl...
> BlankNone. I pasted your code into my QA and it parses correctly (as I
> assumed). When I ran it, I got the expected:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'DB1..Test1'.
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Matthew Beirn" <mbeirn@.ssimed.com> wrote in message
> news:OgBOO3IjFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Any Other Suggestions?......
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:%23r5pqsIjFHA.3300@.TK2MSFTNGP15.phx.gbl...
> Try specifying the object owner:
> Select *
> FROM DB1.dbo.Test1
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Matthew Beirn" <mbeirn@.ssimed.com> wrote in message
> news:%23IGqqbIjFHA.3704@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I'm using Query Analyzer and I'm trying to select from a table on
> another database...
> i.e..I'm on DB2 in query analyzer and this is what my query looks
> like
> Select *
> FROM DB1..Test1
> But I'm getting an error
> Server: Msg 170, Level 15, State 1, Line 2
> Line 2: Incorrect syntax near 'DB1.'.
> This query worked on my local machine... Could it be a set-up issue
> on a different server?
> Thanks for any help,
> Matt|||Ahh, sloppy me... :-)
Thanks for catching that, Kevin.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23YgOUYJjFHA.1044@.tk2msftngp13.phx.gbl...
> That was me, not the OP...;-)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your quest
ions
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:e9vm%23DJjFHA.3704@.TK2MSFTNGP10.phx.gbl...
>
Saturday, February 25, 2012
Access sql server behide firewall?
How do I access a sql server behide an ISA server? What are the steps requir
ed to access via query analyzer from the internet?Have you looked at this article:
HOWTO: Configure ISA Server 2000 and Enterprise Manager to Connect Through
ISA to a SQL Server
http://support.microsoft.com/defaul...kb;en-us;299673
Rand
This posting is provided "as is" with no warranties and confers no rights.
ed to access via query analyzer from the internet?Have you looked at this article:
HOWTO: Configure ISA Server 2000 and Enterprise Manager to Connect Through
ISA to a SQL Server
http://support.microsoft.com/defaul...kb;en-us;299673
Rand
This posting is provided "as is" with no warranties and confers no rights.
Access sql server behide firewall?
How do I access a sql server behide an isa server? What are the steps required to access via query analyzer from the internet?
Have you looked at this article:
HOWTO: Configure ISA Server 2000 and Enterprise Manager to Connect Through
ISA to a SQL Server
http://support.microsoft.com/default...b;en-us;299673
Rand
This posting is provided "as is" with no warranties and confers no rights.
Have you looked at this article:
HOWTO: Configure ISA Server 2000 and Enterprise Manager to Connect Through
ISA to a SQL Server
http://support.microsoft.com/default...b;en-us;299673
Rand
This posting is provided "as is" with no warranties and confers no rights.
Sunday, February 19, 2012
Access otehr sql server ina domain w/ Query Analyzer
Hi everybody,
I do not know if this is the correct area to post this topic? So, How to access
different sql server with query analyzer? Usually, when to install sql server, it
access the database server locally installed, now I like to access other sql server
within a domain using query analyzer. How to configure this in order I could use
query analyzer to access other sql server within a domain? Thanks in advanced.
den2005
Simply choose Connect from the menu and connect to a different server. If you want to you another server in your query you can setup a linked server whereas you can query across different servers in one query.HTH, jens Suessmeyer.
Access MSSQL on diffrent port
Hi,
Im trying to access MSSQL 2000 instance on diffrent port using Query analyzer
is this possible?
--
Marcin S.You can only connect through the port SQL Server is listening on...are you
wanting to change the port at the server level?
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> Hi,
> Im trying to access MSSQL 2000 instance on diffrent port using Query
> analyzer
> is this possible?
>
> --
> Marcin S.|||Hi,
I'm running two instances om the MSSQL server och they have differnt ports
1434 and 1435
I want to remotly to connect to 192.168.0.150:1434 and/or 192.168.0.150:1435
the both servers are on separeta DMZ and the SQL connection passing thru an
Firewall. I can telnet to this ports so the fire wall is working correct by i
dont know how to specify a port in QA an in the connection string.
Marcin S.
"Kevin3NF" wrote:
> You can only connect through the port SQL Server is listening on...are you
> wanting to change the port at the server level?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> > Hi,
> >
> > Im trying to access MSSQL 2000 instance on diffrent port using Query
> > analyzer
> > is this possible?
> >
> >
> > --
> > Marcin S.
>
>|||assuming you have a vpn connection established to get you on the local LAN:
tcp:192.168.0.150,1434
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
> Hi,
> I'm running two instances om the MSSQL server och they have differnt ports
> 1434 and 1435
> I want to remotly to connect to 192.168.0.150:1434 and/or
> 192.168.0.150:1435
> the both servers are on separeta DMZ and the SQL connection passing thru
> an
> Firewall. I can telnet to this ports so the fire wall is working correct
> by i
> dont know how to specify a port in QA an in the connection string.
>
> --
> Marcin S.
>
> "Kevin3NF" wrote:
>> You can only connect through the port SQL Server is listening on...are
>> you
>> wanting to change the port at the server level?
>> --
>> Kevin Hill
>> President
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>> www.experts-exchange.com - experts compete for points to answer your
>> questions
>>
>> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
>> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
>> > Hi,
>> >
>> > Im trying to access MSSQL 2000 instance on diffrent port using Query
>> > analyzer
>> > is this possible?
>> >
>> >
>> > --
>> > Marcin S.
>>|||No there is no VPN the SQL server is just separated from the webserver by a
firewall.
--
Marcin S.
"Kevin3NF" wrote:
> assuming you have a vpn connection established to get you on the local LAN:
> tcp:192.168.0.150,1434
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
> > Hi,
> >
> > I'm running two instances om the MSSQL server och they have differnt ports
> >
> > 1434 and 1435
> >
> > I want to remotly to connect to 192.168.0.150:1434 and/or
> > 192.168.0.150:1435
> > the both servers are on separeta DMZ and the SQL connection passing thru
> > an
> > Firewall. I can telnet to this ports so the fire wall is working correct
> > by i
> > dont know how to specify a port in QA an in the connection string.
> >
> >
> > --
> > Marcin S.
> >
> >
> > "Kevin3NF" wrote:
> >
> >> You can only connect through the port SQL Server is listening on...are
> >> you
> >> wanting to change the port at the server level?
> >>
> >> --
> >> Kevin Hill
> >> President
> >> 3NF Consulting
> >>
> >> www.3nf-inc.com/NewsGroups.htm
> >>
> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> >>
> >> www.experts-exchange.com - experts compete for points to answer your
> >> questions
> >>
> >>
> >> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> >> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> >> > Hi,
> >> >
> >> > Im trying to access MSSQL 2000 instance on diffrent port using Query
> >> > analyzer
> >> > is this possible?
> >> >
> >> >
> >> > --
> >> > Marcin S.
> >>
> >>
> >>
>
>|||Hi,
this is almost working but i think i must specify the instance how to do tha
192.168.0.150\MSSQL2,1435 '
My instancename is MSSQL1 and MSSQL2
Marcin S.
"Kevin3NF" wrote:
> assuming you have a vpn connection established to get you on the local LAN:
> tcp:192.168.0.150,1434
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
> > Hi,
> >
> > I'm running two instances om the MSSQL server och they have differnt ports
> >
> > 1434 and 1435
> >
> > I want to remotly to connect to 192.168.0.150:1434 and/or
> > 192.168.0.150:1435
> > the both servers are on separeta DMZ and the SQL connection passing thru
> > an
> > Firewall. I can telnet to this ports so the fire wall is working correct
> > by i
> > dont know how to specify a port in QA an in the connection string.
> >
> >
> > --
> > Marcin S.
> >
> >
> > "Kevin3NF" wrote:
> >
> >> You can only connect through the port SQL Server is listening on...are
> >> you
> >> wanting to change the port at the server level?
> >>
> >> --
> >> Kevin Hill
> >> President
> >> 3NF Consulting
> >>
> >> www.3nf-inc.com/NewsGroups.htm
> >>
> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> >>
> >> www.experts-exchange.com - experts compete for points to answer your
> >> questions
> >>
> >>
> >> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> >> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> >> > Hi,
> >> >
> >> > Im trying to access MSSQL 2000 instance on diffrent port using Query
> >> > analyzer
> >> > is this possible?
> >> >
> >> >
> >> > --
> >> > Marcin S.
> >>
> >>
> >>
>
>|||192.168.0.150\MSSQL2,1435 is correct.
--
--
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/
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:4818A5FC-FE43-4C54-ABF9-25FA67B4C23D@.microsoft.com...
> Hi,
> this is almost working but i think i must specify the instance how to do
> tha
> 192.168.0.150\MSSQL2,1435 '
> My instancename is MSSQL1 and MSSQL2
>
> --
> Marcin S.
>
> "Kevin3NF" wrote:
>> assuming you have a vpn connection established to get you on the local
>> LAN:
>> tcp:192.168.0.150,1434
>> --
>> Kevin Hill
>> President
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>> www.experts-exchange.com - experts compete for points to answer your
>> questions
>>
>> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
>> news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
>> > Hi,
>> >
>> > I'm running two instances om the MSSQL server och they have differnt
>> > ports
>> >
>> > 1434 and 1435
>> >
>> > I want to remotly to connect to 192.168.0.150:1434 and/or
>> > 192.168.0.150:1435
>> > the both servers are on separeta DMZ and the SQL connection passing
>> > thru
>> > an
>> > Firewall. I can telnet to this ports so the fire wall is working
>> > correct
>> > by i
>> > dont know how to specify a port in QA an in the connection string.
>> >
>> >
>> > --
>> > Marcin S.
>> >
>> >
>> > "Kevin3NF" wrote:
>> >
>> >> You can only connect through the port SQL Server is listening on...are
>> >> you
>> >> wanting to change the port at the server level?
>> >>
>> >> --
>> >> Kevin Hill
>> >> President
>> >> 3NF Consulting
>> >>
>> >> www.3nf-inc.com/NewsGroups.htm
>> >>
>> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area
>> >> DBAs.
>> >>
>> >> www.experts-exchange.com - experts compete for points to answer your
>> >> questions
>> >>
>> >>
>> >> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
>> >> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
>> >> > Hi,
>> >> >
>> >> > Im trying to access MSSQL 2000 instance on diffrent port using Query
>> >> > analyzer
>> >> > is this possible?
>> >> >
>> >> >
>> >> > --
>> >> > Marcin S.
>> >>
>> >>
>> >>
>>
Im trying to access MSSQL 2000 instance on diffrent port using Query analyzer
is this possible?
--
Marcin S.You can only connect through the port SQL Server is listening on...are you
wanting to change the port at the server level?
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> Hi,
> Im trying to access MSSQL 2000 instance on diffrent port using Query
> analyzer
> is this possible?
>
> --
> Marcin S.|||Hi,
I'm running two instances om the MSSQL server och they have differnt ports
1434 and 1435
I want to remotly to connect to 192.168.0.150:1434 and/or 192.168.0.150:1435
the both servers are on separeta DMZ and the SQL connection passing thru an
Firewall. I can telnet to this ports so the fire wall is working correct by i
dont know how to specify a port in QA an in the connection string.
Marcin S.
"Kevin3NF" wrote:
> You can only connect through the port SQL Server is listening on...are you
> wanting to change the port at the server level?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> > Hi,
> >
> > Im trying to access MSSQL 2000 instance on diffrent port using Query
> > analyzer
> > is this possible?
> >
> >
> > --
> > Marcin S.
>
>|||assuming you have a vpn connection established to get you on the local LAN:
tcp:192.168.0.150,1434
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
> Hi,
> I'm running two instances om the MSSQL server och they have differnt ports
> 1434 and 1435
> I want to remotly to connect to 192.168.0.150:1434 and/or
> 192.168.0.150:1435
> the both servers are on separeta DMZ and the SQL connection passing thru
> an
> Firewall. I can telnet to this ports so the fire wall is working correct
> by i
> dont know how to specify a port in QA an in the connection string.
>
> --
> Marcin S.
>
> "Kevin3NF" wrote:
>> You can only connect through the port SQL Server is listening on...are
>> you
>> wanting to change the port at the server level?
>> --
>> Kevin Hill
>> President
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>> www.experts-exchange.com - experts compete for points to answer your
>> questions
>>
>> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
>> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
>> > Hi,
>> >
>> > Im trying to access MSSQL 2000 instance on diffrent port using Query
>> > analyzer
>> > is this possible?
>> >
>> >
>> > --
>> > Marcin S.
>>|||No there is no VPN the SQL server is just separated from the webserver by a
firewall.
--
Marcin S.
"Kevin3NF" wrote:
> assuming you have a vpn connection established to get you on the local LAN:
> tcp:192.168.0.150,1434
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
> > Hi,
> >
> > I'm running two instances om the MSSQL server och they have differnt ports
> >
> > 1434 and 1435
> >
> > I want to remotly to connect to 192.168.0.150:1434 and/or
> > 192.168.0.150:1435
> > the both servers are on separeta DMZ and the SQL connection passing thru
> > an
> > Firewall. I can telnet to this ports so the fire wall is working correct
> > by i
> > dont know how to specify a port in QA an in the connection string.
> >
> >
> > --
> > Marcin S.
> >
> >
> > "Kevin3NF" wrote:
> >
> >> You can only connect through the port SQL Server is listening on...are
> >> you
> >> wanting to change the port at the server level?
> >>
> >> --
> >> Kevin Hill
> >> President
> >> 3NF Consulting
> >>
> >> www.3nf-inc.com/NewsGroups.htm
> >>
> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> >>
> >> www.experts-exchange.com - experts compete for points to answer your
> >> questions
> >>
> >>
> >> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> >> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> >> > Hi,
> >> >
> >> > Im trying to access MSSQL 2000 instance on diffrent port using Query
> >> > analyzer
> >> > is this possible?
> >> >
> >> >
> >> > --
> >> > Marcin S.
> >>
> >>
> >>
>
>|||Hi,
this is almost working but i think i must specify the instance how to do tha
192.168.0.150\MSSQL2,1435 '
My instancename is MSSQL1 and MSSQL2
Marcin S.
"Kevin3NF" wrote:
> assuming you have a vpn connection established to get you on the local LAN:
> tcp:192.168.0.150,1434
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
> > Hi,
> >
> > I'm running two instances om the MSSQL server och they have differnt ports
> >
> > 1434 and 1435
> >
> > I want to remotly to connect to 192.168.0.150:1434 and/or
> > 192.168.0.150:1435
> > the both servers are on separeta DMZ and the SQL connection passing thru
> > an
> > Firewall. I can telnet to this ports so the fire wall is working correct
> > by i
> > dont know how to specify a port in QA an in the connection string.
> >
> >
> > --
> > Marcin S.
> >
> >
> > "Kevin3NF" wrote:
> >
> >> You can only connect through the port SQL Server is listening on...are
> >> you
> >> wanting to change the port at the server level?
> >>
> >> --
> >> Kevin Hill
> >> President
> >> 3NF Consulting
> >>
> >> www.3nf-inc.com/NewsGroups.htm
> >>
> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> >>
> >> www.experts-exchange.com - experts compete for points to answer your
> >> questions
> >>
> >>
> >> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> >> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> >> > Hi,
> >> >
> >> > Im trying to access MSSQL 2000 instance on diffrent port using Query
> >> > analyzer
> >> > is this possible?
> >> >
> >> >
> >> > --
> >> > Marcin S.
> >>
> >>
> >>
>
>|||192.168.0.150\MSSQL2,1435 is correct.
--
--
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/
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:4818A5FC-FE43-4C54-ABF9-25FA67B4C23D@.microsoft.com...
> Hi,
> this is almost working but i think i must specify the instance how to do
> tha
> 192.168.0.150\MSSQL2,1435 '
> My instancename is MSSQL1 and MSSQL2
>
> --
> Marcin S.
>
> "Kevin3NF" wrote:
>> assuming you have a vpn connection established to get you on the local
>> LAN:
>> tcp:192.168.0.150,1434
>> --
>> Kevin Hill
>> President
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>> www.experts-exchange.com - experts compete for points to answer your
>> questions
>>
>> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
>> news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
>> > Hi,
>> >
>> > I'm running two instances om the MSSQL server och they have differnt
>> > ports
>> >
>> > 1434 and 1435
>> >
>> > I want to remotly to connect to 192.168.0.150:1434 and/or
>> > 192.168.0.150:1435
>> > the both servers are on separeta DMZ and the SQL connection passing
>> > thru
>> > an
>> > Firewall. I can telnet to this ports so the fire wall is working
>> > correct
>> > by i
>> > dont know how to specify a port in QA an in the connection string.
>> >
>> >
>> > --
>> > Marcin S.
>> >
>> >
>> > "Kevin3NF" wrote:
>> >
>> >> You can only connect through the port SQL Server is listening on...are
>> >> you
>> >> wanting to change the port at the server level?
>> >>
>> >> --
>> >> Kevin Hill
>> >> President
>> >> 3NF Consulting
>> >>
>> >> www.3nf-inc.com/NewsGroups.htm
>> >>
>> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area
>> >> DBAs.
>> >>
>> >> www.experts-exchange.com - experts compete for points to answer your
>> >> questions
>> >>
>> >>
>> >> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
>> >> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
>> >> > Hi,
>> >> >
>> >> > Im trying to access MSSQL 2000 instance on diffrent port using Query
>> >> > analyzer
>> >> > is this possible?
>> >> >
>> >> >
>> >> > --
>> >> > Marcin S.
>> >>
>> >>
>> >>
>>
Access MSDE Database
Hi All,
Is it possible to access MSDE with either Enterprise Manager or Query
Analyzer. If so can you let me know how too?
Thanks.yes...just register it like you would any other SQL Server (EM) or make a
standard connection in QA using the proper authentication. Those two tools
make no distinction between SQL Standard/Enterprise and MSDE
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"David" <David@.discussions.microsoft.com> wrote in message
news:FF61C2EF-0878-4D9D-8117-22863BE95BD9@.microsoft.com...
> Hi All,
> Is it possible to access MSDE with either Enterprise Manager or Query
> Analyzer. If so can you let me know how too?
> Thanks.|||But you need to purchase a CAL :)
Thanks
Hari
SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:FF61C2EF-0878-4D9D-8117-22863BE95BD9@.microsoft.com...
> Hi All,
> Is it possible to access MSDE with either Enterprise Manager or Query
> Analyzer. If so can you let me know how too?
> Thanks.|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uPlsM9gkFHA.3936@.TK2MSFTNGP10.phx.gbl...
> But you need to purchase a CAL :)
>
Or by a copy of SQL Server Developer Edition for $49.95, which gives you
full use of the tools and server components for designing, developing and
testing your applications.
David
Is it possible to access MSDE with either Enterprise Manager or Query
Analyzer. If so can you let me know how too?
Thanks.yes...just register it like you would any other SQL Server (EM) or make a
standard connection in QA using the proper authentication. Those two tools
make no distinction between SQL Standard/Enterprise and MSDE
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"David" <David@.discussions.microsoft.com> wrote in message
news:FF61C2EF-0878-4D9D-8117-22863BE95BD9@.microsoft.com...
> Hi All,
> Is it possible to access MSDE with either Enterprise Manager or Query
> Analyzer. If so can you let me know how too?
> Thanks.|||But you need to purchase a CAL :)
Thanks
Hari
SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:FF61C2EF-0878-4D9D-8117-22863BE95BD9@.microsoft.com...
> Hi All,
> Is it possible to access MSDE with either Enterprise Manager or Query
> Analyzer. If so can you let me know how too?
> Thanks.|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uPlsM9gkFHA.3936@.TK2MSFTNGP10.phx.gbl...
> But you need to purchase a CAL :)
>
Or by a copy of SQL Server Developer Edition for $49.95, which gives you
full use of the tools and server components for designing, developing and
testing your applications.
David
Thursday, February 9, 2012
Access denied in "Best Practices Analyzer"
Hi.
I get this error on certain results in the compliance report. It only seems
to happen when i use SQL Server authentication
Error while executing the Best Practice Group. See the log file
test_JRSJF0J_0001_(local)_sqlbpa.log. Error message: Access is denied.
Anyone?
Hi Michael
Is the user account used to scan a valid login into SQL Server? Can you
connect from Query Analyzer? Does it have access to all databases specified
in the scan?
If you still have problems, you can use SQL Profiler and log exceptions to
see server side activity and identify the statement/operation that is
failing the access check.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael_Sergel" <MichaelSergel@.discussions.microsoft.com> wrote in message
news:AD22C6B6-CCA9-49A6-B188-18EB8CEAB8BE@.microsoft.com...
> Hi.
> I get this error on certain results in the compliance report. It only
seems
> to happen when i use SQL Server authentication
> Error while executing the Best Practice Group. See the log file
> test_JRSJF0J_0001_(local)_sqlbpa.log. Error message: Access is denied.
> Anyone?
>
I get this error on certain results in the compliance report. It only seems
to happen when i use SQL Server authentication
Error while executing the Best Practice Group. See the log file
test_JRSJF0J_0001_(local)_sqlbpa.log. Error message: Access is denied.
Anyone?
Hi Michael
Is the user account used to scan a valid login into SQL Server? Can you
connect from Query Analyzer? Does it have access to all databases specified
in the scan?
If you still have problems, you can use SQL Profiler and log exceptions to
see server side activity and identify the statement/operation that is
failing the access check.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael_Sergel" <MichaelSergel@.discussions.microsoft.com> wrote in message
news:AD22C6B6-CCA9-49A6-B188-18EB8CEAB8BE@.microsoft.com...
> Hi.
> I get this error on certain results in the compliance report. It only
seems
> to happen when i use SQL Server authentication
> Error while executing the Best Practice Group. See the log file
> test_JRSJF0J_0001_(local)_sqlbpa.log. Error message: Access is denied.
> Anyone?
>
access denied for query analyzer
The sqlserver 2000 was installed on the box
using a domain usr account which is in local admin group.
A local user account logged on and tried to launch query
analyzer and got access denied. How to fix this problem
so that the local users can have launch the sqlserver
software? Any help will be appreciated.you need to grant the user the login permission onto sql server and the
login needs to be mapped to a database user or granted permissions or added
to a database roles.
Check sql books online sp_grantlogin and sp_addlogin , sp_grantdbaccess
--
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Wen Chang" <wchang@.siac.com> wrote in message
news:036001c3dde0$d0049580$a001280a@.phx.gbl...
> The sqlserver 2000 was installed on the box
> using a domain usr account which is in local admin group.
> A local user account logged on and tried to launch query
> analyzer and got access denied. How to fix this problem
> so that the local users can have launch the sqlserver
> software? Any help will be appreciated.
>
using a domain usr account which is in local admin group.
A local user account logged on and tried to launch query
analyzer and got access denied. How to fix this problem
so that the local users can have launch the sqlserver
software? Any help will be appreciated.you need to grant the user the login permission onto sql server and the
login needs to be mapped to a database user or granted permissions or added
to a database roles.
Check sql books online sp_grantlogin and sp_addlogin , sp_grantdbaccess
--
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Wen Chang" <wchang@.siac.com> wrote in message
news:036001c3dde0$d0049580$a001280a@.phx.gbl...
> The sqlserver 2000 was installed on the box
> using a domain usr account which is in local admin group.
> A local user account logged on and tried to launch query
> analyzer and got access denied. How to fix this problem
> so that the local users can have launch the sqlserver
> software? Any help will be appreciated.
>
access denied for query analyzer
The sqlserver 2000 was installed on the box
using a domain usr account which is in local admin group.
A local user account logged on and tried to launch query
analyzer and got access denied. How to fix this problem
so that the local users can have launch the sqlserver
software? Any help will be appreciated.you need to grant the user the login permission onto sql server and the
login needs to be mapped to a database user or granted permissions or added
to a database roles.
Check sql books online sp_grantlogin and sp_addlogin , sp_grantdbaccess
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Wen Chang" <wchang@.siac.com> wrote in message
news:036001c3dde0$d0049580$a001280a@.phx.gbl...
using a domain usr account which is in local admin group.
A local user account logged on and tried to launch query
analyzer and got access denied. How to fix this problem
so that the local users can have launch the sqlserver
software? Any help will be appreciated.you need to grant the user the login permission onto sql server and the
login needs to be mapped to a database user or granted permissions or added
to a database roles.
Check sql books online sp_grantlogin and sp_addlogin , sp_grantdbaccess
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Wen Chang" <wchang@.siac.com> wrote in message
news:036001c3dde0$d0049580$a001280a@.phx.gbl...
quote:
> The sqlserver 2000 was installed on the box
> using a domain usr account which is in local admin group.
> A local user account logged on and tried to launch query
> analyzer and got access denied. How to fix this problem
> so that the local users can have launch the sqlserver
> software? Any help will be appreciated.
>
Subscribe to:
Posts (Atom)