Hi All,
I can connect to my MSDE server by logging in as SA from the command line
but not through the ODBC manager utility in windows. I need to setup system
DSNs for a few applications but can't because they require I use SQL
authentication. When I reach that step in the ODBC manager I type in SA and
the password and hit next I get a 18456 "login failed for sa" error. My
server is in mixed mode (I checked the registry), the domain admins group has
login privilages to MSDE, I have no firewall active on any NICs, and none of
my passwords contain a semicolon. I have no clue what I'm missing here. Can
some one point me in the right direction or link me to a good article on how
to setup system dsns through the command line?
Thanks,
Prikly Pete Peterson
MSDE can only be used as the source of the data. It's not licensed to host
Reporting Services (as we discuss in our Reporting Services
book --www.sqlreportingservices.net). Chapter 2 (freely downloadable from
the site) explains why.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"ComfortablySAD" <ComfortablySAD@.discussions.microsoft.com> wrote in message
news:32E686BF-63A6-4DFF-9A7D-A00E8B6CAE09@.microsoft.com...
> Hi All,
> I can connect to my MSDE server by logging in as SA from the command line
> but not through the ODBC manager utility in windows. I need to setup
> system
> DSNs for a few applications but can't because they require I use SQL
> authentication. When I reach that step in the ODBC manager I type in SA
> and
> the password and hit next I get a 18456 "login failed for sa" error. My
> server is in mixed mode (I checked the registry), the domain admins group
> has
> login privilages to MSDE, I have no firewall active on any NICs, and none
> of
> my passwords contain a semicolon. I have no clue what I'm missing here.
> Can
> some one point me in the right direction or link me to a good article on
> how
> to setup system dsns through the command line?
> Thanks,
> Prikly Pete Peterson
sql
Showing posts with label logging. Show all posts
Showing posts with label logging. Show all posts
Thursday, March 29, 2012
Tuesday, March 20, 2012
Can't access merge agent properties
I'm trying to set the logging level on a merge agent. I've read
KB312292. When I right click on the agent and select properties some
text flashes in the status bar but no dialog is displayed. I'm using
SQL 2K SP4.
TIA
Is this for pulls configure through ActiveX scripts/programming? or WSM
pulls?
You can't do it for these.
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
"Darren" <darren@.nospam.com> wrote in message
news:eiaIuotFGHA.3120@.TK2MSFTNGP10.phx.gbl...
> I'm trying to set the logging level on a merge agent. I've read KB312292.
> When I right click on the agent and select properties some text flashes in
> the status bar but no dialog is displayed. I'm using SQL 2K SP4.
> TIA
|||Hilary Cotter wrote:
> Is this for pulls configure through ActiveX scripts/programming? or WSM
> pulls?
> You can't do it for these.
>
It was created from a C# app using the merge object. So how can I
change the logging level for that agent without using what is described
in the KB article?
|||use the status event to get messages. You will probably have to configure
the agent to use the verbose profile to see these messages. I would restart
on failure to use the new profile; running with the verbose profile does not
perform well.
Let me know if you need code for this.
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
"Darren" <Darren@.nospam.nospam> wrote in message
news:elcSkBvFGHA.3200@.tk2msftngp13.phx.gbl...
> Hilary Cotter wrote:
> It was created from a C# app using the merge object. So how can I change
> the logging level for that agent without using what is described in the KB
> article?
|||Thanks.
I don't this the status event callback provides enough detail.
I'm trying to get the equivalent of the following options
-output c:\log.txt -outverboselevel 3
I don't see either in the merge profile options.
Hilary Cotter wrote:
> use the status event to get messages. You will probably have to configure
> the agent to use the verbose profile to see these messages. I would restart
> on failure to use the new profile; running with the verbose profile does not
> perform well.
> Let me know if you need code for this.
>
KB312292. When I right click on the agent and select properties some
text flashes in the status bar but no dialog is displayed. I'm using
SQL 2K SP4.
TIA
Is this for pulls configure through ActiveX scripts/programming? or WSM
pulls?
You can't do it for these.
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
"Darren" <darren@.nospam.com> wrote in message
news:eiaIuotFGHA.3120@.TK2MSFTNGP10.phx.gbl...
> I'm trying to set the logging level on a merge agent. I've read KB312292.
> When I right click on the agent and select properties some text flashes in
> the status bar but no dialog is displayed. I'm using SQL 2K SP4.
> TIA
|||Hilary Cotter wrote:
> Is this for pulls configure through ActiveX scripts/programming? or WSM
> pulls?
> You can't do it for these.
>
It was created from a C# app using the merge object. So how can I
change the logging level for that agent without using what is described
in the KB article?
|||use the status event to get messages. You will probably have to configure
the agent to use the verbose profile to see these messages. I would restart
on failure to use the new profile; running with the verbose profile does not
perform well.
Let me know if you need code for this.
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
"Darren" <Darren@.nospam.nospam> wrote in message
news:elcSkBvFGHA.3200@.tk2msftngp13.phx.gbl...
> Hilary Cotter wrote:
> It was created from a C# app using the merge object. So how can I change
> the logging level for that agent without using what is described in the KB
> article?
|||Thanks.
I don't this the status event callback provides enough detail.
I'm trying to get the equivalent of the following options
-output c:\log.txt -outverboselevel 3
I don't see either in the merge profile options.
Hilary Cotter wrote:
> use the status event to get messages. You will probably have to configure
> the agent to use the verbose profile to see these messages. I would restart
> on failure to use the new profile; running with the verbose profile does not
> perform well.
> Let me know if you need code for this.
>
Subscribe to:
Posts (Atom)