Connect to database without showing the "Connect to Server" dialog box?

Is it possible to configure the SQL Server Management Studio to behave like good old Enterprise Manager, so that it automatically connects to my configured servers without showing the "Connect to Server" dialog box every time upon startup?

After successlessly searching Google and these forums, I still found no suitable answer to this question (maybe beside this one).

Thanks
Uwe

You ae right this is not possible, perhaps you can suggest that as a feature request on connect.microsoft.com ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Done:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=180590

Thanks, Jens .|||You got my vote.

-Jens.|||Strange - they marked the ticket as "closed" and "solved", but no further comments.

Anyone knows what this actually means? IS it already present and I did not found it? Or will it be implemented in a further version?

Thanks
Uwe

Connect MS SQL Server to UniData tables

Does anyone know how to configure MS Sql Server to link or connect to a UniData db table ?

I know our company would be interested in doing this... if you ever find out would be interested in finding out.
|||

I have been working on such an engine at the company I am currently employed at and would like to know if there are alternatives. I can say from personal experience that the normalization process is the single killer. It is do-able, but there are a number of hoops to jump through.. It all comes down to the amount of data you need replicated into SQL Server.

Configuring subscription database as publication.

Hi, I need to configure this scenario
Part 1: Transactional publication configured in database A, the
subscriber is database B.
Part II: Configure a transactional publication in database B and send it
to database C and D.
I already configure the part 1 of the scenario. But when i try to
configure part B, i have the problem that the tables in database b Dont
have primary key, I try changing this option on each article:
"Delete all data in the the existing table". Assuming that if i already
create the tables with primary key, it will work, but it didnt.
Do somebody know how to configure it?
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Maria,
on the article properties, select to take the declarative referential
integrity. This'll ensure that PKs don't become just unique indexes on the
subscriber, and the PKs will be created there.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Configuring SSIS package to read a value before executin

Hi,

Is it possible in any ways to Configure a SSIS package in such a way that based on the User Input the package runs. For e.g if there is a table which has say 10 distinct groups. Normal SSIS package would ideally pick all the data from the source to the Destination

I want to know how to configure in Such a way that I should be able to say Group X as the input and data related to GroupX alone should be copied.

Select * from SomeTable where GroupName = @.CongigVar.

how to achieve something like this?

thanks

Hello,

What kind of input are you intrested in getting?

If you have the group name that you want to get information from in a table, you can, in control flow, make a query to a table, and put it on a variable, then on the data flow you can use the variable as a parameter.

To use it on a parameter your query should be

"Select * from SomeTable where GroupName = ?"

Then in the parameter button on the left you choose the variable that will pass tha value to the question mark.

Is that good for you?

Regards,

|||

Hello,

I think that might just be what I need, but when I tried creating one, its failing with the error, 'Parameter Name Unrecognized'. I think am doing it wrongly. Can you post some links that explains how to put a value from a table onto a variable, and then use it as i/p to a Data flow?

thanks

|||

Nfrf wrote:

Hello,

What kind of input are you intrested in getting?

If you have the group name that you want to get information from in a table, you can, in control flow, make a query to a table, and put it on a variable, then on the data flow you can use the variable as a parameter.

To use it on a parameter your query should be

"Select * from SomeTable where GroupName = ?"

Then in the parameter button on the left you choose the variable that will pass tha value to the question mark.

Is that good for you?

Regards,

There's no need to store values in a table. You can parameterize your package by passing it values when you call it. Explore the /SET option of dtexec. All the information you require is in Books Online.

-Jamie

|||

Yes it is true. I just gave him a way.

The thing that i thnik he wanted to know was the parameter on the query.

Even so thanks

Configuring SQLServerAgent 2000 mail session

How do I configure the SQLServerAgent 2000 mail session? Do I need MS Outlook installed on the server?How do I configure the SQLServerAgent 2000 mail session? Do I need MS Outlook installed on the server?

Yes you do. More specifically, you need MS Outlook 2000.

Try this link (http://support.microsoft.com/kb/263556). Bear in mind that SQL Agent Mail and SQL Mail are different, and must be configured separately (though you don't have to configure both).

In general, I HATE SQL Agent Mail. If Outlook hangs or whatever reason, you can potentially hang your entire job scheduling process. It can get real ugly real fast.

Google SMTP solutions for SQL 2000 and you'll find a lot of other options. Best bet, though, is to go with SQL 2005 and use the new database mail feature (which is SMTP based).

Regards,

hmscott

Configuring SQLMAIL

Hi
I wanted to send an email through sql server 2000.Before sending i need to
configure a profilename in Sqlmail from enterprise mananger.
And i took profile name from controlpanel>mail
While entering MAPI profile name and click on test button i get the below
error
xp_test_mapi_profile:failed with mail error 0x8004011
I have below environment on my system
---
OS : windows xp with updated service pack
OutLook 2000 configured with exchange server
can u help me out from this problem or can u tell step by step process of
configuringHi
Login with the SQL Server Service Domain Account.
Setup the mail profile.
Logout
Login again and then select the profile you created earlier under the
Support Service > SQL Mail in EM. If it is not in the dropdown, the profile
is not correct.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TreeView Custom" wrote:
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>|||Hi,
I think information on this link will help, especially on the step by step:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba01/html/SQLServerE-mail.asp
Thanks,
RdR
"TreeView Custom" <TreeViewCustom@.discussions.microsoft.com> wrote in
message news:9CF6600D-741C-4736-AC14-1955499FE8DE@.microsoft.com...
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>

Configuring SQLdataadapter with nested query.

How to configure sqldatadapter with query like

"select name ,id from tlb1 where id in (select id from tlb2 where dept=@.dept)"

Is the nested subquery is not allowed while configuring sqldaadapter?

Swati

Hi Swati Jain,

Is the nested subquery is not allowed while configuring sqldaadapter?

I don't think so. I tested your code in my project and it works fine. There must be something wrong somewhere else in your code. Also a workaroud here is to use table join instead of nested sql.

Hope my suggestion helps

Configuring SQLAgent for sending email

Hi All,

I need some help in configure our SQL 2K & 2K5 servers to send notification on job failers. Have created operators on SQL 2k but when i try to do a test mail it fails saying mai session is not running. I go to properties of the Sql agent to turn on mail session but it is grayed out. Can someone please direct me to the steps I need to take when setting up sql server with email capability. Do I have to install office (outlook on the sql server box) in order for emailing to work?

Thanks in advance for your help.

Nats

On SQL 2000 servers, you will need a MAPI client installed (e.g., Outlook).

However, I recommend checking out the usage of xp_smtp_sendmail -an alternative to installing Outlook and all of its issues.

Mail –Sending
SQL 2000 - http://www.sqldev.net/xp/xpsmtp.htm
http://www.aspfaq.com/show.asp?id=2403

configuring SQL server 7.0 client on a windows xp pro machine

I am about to attempt to configure a SQL server 7.0 client on a windows XP
workstation. Does anyone have any suggestions or advice that will make this
install go smoothly?
I am not sure what will happen, but any advice would be helpful.
Edward Letendre
Client?
As in the MDAC stack?
XP has MDAC v2.8, which is backward compatible with SQL 7.0
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/
"Edward Letendre" <EdwardLetendre@.discussions.microsoft.com> wrote in
message news:B78F2F42-36E6-496A-B09F-56E27B2CA50B@.microsoft.com...
> I am about to attempt to configure a SQL server 7.0 client on a windows XP
> workstation. Does anyone have any suggestions or advice that will make
this
> install go smoothly?
> I am not sure what will happen, but any advice would be helpful.
> Edward Letendre
>
|||Actually I was talking about installing the SQL server client software on a
windows xp professional workstation. I just inserted the cd and followed the
instructions. Everything seemed to work.
I also setup the ODBC settings for the various databases that were to be
connected for various applications that are used on this workstation.
Are there anything else I should look into with SQL server 7.0 and windows
xp professional.
Are there any updates to any of the drivers, applications, etc?
Edward Letendre.
"Mike Epprecht (SQL MVP)" wrote:

> Client?
> As in the MDAC stack?
> XP has MDAC v2.8, which is backward compatible with SQL 7.0
> 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/
> "Edward Letendre" <EdwardLetendre@.discussions.microsoft.com> wrote in
> message news:B78F2F42-36E6-496A-B09F-56E27B2CA50B@.microsoft.com...
> this
>
>
|||Just make sure you apply the latest SQL 7 Service Pack to your client.
David Gugick
Imceda Software
www.imceda.com
Edward Letendre wrote:
> Actually I was talking about installing the SQL server client
> software on a windows xp professional workstation. I just inserted
> the cd and followed the instructions. Everything seemed to work.
> I also setup the ODBC settings for the various databases that were
> to be connected for various applications that are used on this
> workstation.
> Are there anything else I should look into with SQL server 7.0 and
> windows xp professional.
> Are there any updates to any of the drivers, applications, etc?
>

Configuring SQL MAIL

Hi All,

My question is that can I configure SQL MAIL, if my EXCHANGE

SERVER is on different domain and my SQL is running on different

domain.Can anyone guide me for this because I googled a lot

without any result.

I am using SQL SERVER 2000 Enterprise Edition with service pack 3.

and MICROSOFT EXCHANGE SERVER 2000.

Thanks

T.VIf the SQL Server service account is a domain account which can connect
to Exchange, then it should be fine, but that really depends on your
domain configuration. See Q12 here:

http://support.microsoft.com/defaul...kb;en-us;311231

And also this article:

http://support.microsoft.com/defaul...kb;en-us;263556

Simon

Configuring SQL 2005 Database Mail

I am trying to configure Database mail to work with our Exchange server but the only setting that I see is for a SMTP server. I find it hard to believe that this won't work with Exchange. Has anyone got this to work with an Exchange server?

Thanks!
JohnYes it does work with an Exchange Server as long as your exchange server is config'd to support SMTP.

I'm no exchange expert so I can't help you do this but we test Database Mail with Exchange as one of the mail platforms.

-Euan

Configuring SQL

hi all,
i want to develop some script to configure sql externally, can anyone
tell me how can i do so? and wether this is possible or not?
the type of configurations that i need, setting sa password, deleting
guest account,Remove sample databases, Audit Login events, Restrict
CmdExec rights to SysAdmins,...
i want to develop a script to enforce the configurations above by
executing this script
any ideas??
> the type of configurations that i need, setting sa password, deleting
> guest account,Remove sample databases, Audit Login events, Restrict
> CmdExec rights to SysAdmins,...
1) sp_password (setting sa password)
2) sp_dropsuer 'guest'
3) drop database 'dbname' (Remove sample databases)
4) Run sql server Profiler (Audit Login events)
5) Read "CmdExec jobs" in the BOL (Restrict CmdExec rights to SysAdmins),
sp_droprolemember system stored procedure
<Eng.Rana@.gmail.com> wrote in message
news:1163934268.329344.18750@.m73g2000cwd.googlegro ups.com...
> hi all,
> i want to develop some script to configure sql externally, can anyone
> tell me how can i do so? and wether this is possible or not?
> the type of configurations that i need, setting sa password, deleting
> guest account,Remove sample databases, Audit Login events, Restrict
> CmdExec rights to SysAdmins,...
> i want to develop a script to enforce the configurations above by
> executing this script
> any ideas??
>
|||Hi
Some of the things you are wanting to do may be configurable during the
installation see
http://msdn2.microsoft.com/en-us/library/ms144259.aspx if using SQL2005. You
may also want to look at using SMO.
John
"Eng.Rana@.gmail.com" wrote:

> hi all,
> i want to develop some script to configure sql externally, can anyone
> tell me how can i do so? and wether this is possible or not?
> the type of configurations that i need, setting sa password, deleting
> guest account,Remove sample databases, Audit Login events, Restrict
> CmdExec rights to SysAdmins,...
> i want to develop a script to enforce the configurations above by
> executing this script
> any ideas??
>
|||thanx John
but actually i don want to do so while installation, i want to run such
a script to recfonfigure the already installed SQLs, to be secure
i'm using SQL 2000
John Bell wrote:[vbcol=seagreen]
> Hi
> Some of the things you are wanting to do may be configurable during the
> installation see
> http://msdn2.microsoft.com/en-us/library/ms144259.aspx if using SQL2005. You
> may also want to look at using SMO.
> John
> "Eng.Rana@.gmail.com" wrote:

Configuring SQL

hi all,
i want to develop some script to configure sql externally, can anyone
tell me how can i do so' and wether this is possible or not'
the type of configurations that i need, setting sa password, deleting
guest account,Remove sample databases, Audit Login events, Restrict
CmdExec rights to SysAdmins,...
i want to develop a script to enforce the configurations above by
executing this script
any ideas'?> the type of configurations that i need, setting sa password, deleting
> guest account,Remove sample databases, Audit Login events, Restrict
> CmdExec rights to SysAdmins,...
1) sp_password (setting sa password)
2) sp_dropsuer 'guest'
3) drop database 'dbname' (Remove sample databases)
4) Run sql server Profiler (Audit Login events)
5) Read "CmdExec jobs" in the BOL (Restrict CmdExec rights to SysAdmins),
sp_droprolemember system stored procedure
<Eng.Rana@.gmail.com> wrote in message
news:1163934268.329344.18750@.m73g2000cwd.googlegroups.com...
> hi all,
> i want to develop some script to configure sql externally, can anyone
> tell me how can i do so' and wether this is possible or not'
> the type of configurations that i need, setting sa password, deleting
> guest account,Remove sample databases, Audit Login events, Restrict
> CmdExec rights to SysAdmins,...
> i want to develop a script to enforce the configurations above by
> executing this script
> any ideas'?
>|||thanx for the reply
but how can i run these externally, shall i develope some code, using
.NET for example to call these stored procedures
or can i write some script to call them externally, all at once
Uri Dimant wrote:[vbcol=seagreen]
> 1) sp_password (setting sa password)
> 2) sp_dropsuer 'guest'
> 3) drop database 'dbname' (Remove sample databases)
> 4) Run sql server Profiler (Audit Login events)
> 5) Read "CmdExec jobs" in the BOL (Restrict CmdExec rights to SysAdmins),
> sp_droprolemember system stored procedure
>
> <Eng.Rana@.gmail.com> wrote in message
> news:1163934268.329344.18750@.m73g2000cwd.googlegroups.com...|||Yep, you'll have to develop some code in T-SQL as well
<Eng.Rana@.gmail.com> wrote in message
news:1163936328.124164.100050@.m7g2000cwm.googlegroups.com...
> thanx for the reply
> but how can i run these externally, shall i develope some code, using
> .NET for example to call these stored procedures
> or can i write some script to call them externally, all at once
> Uri Dimant wrote:
>|||Hi
Some of the things you are wanting to do may be configurable during the
installation see
http://msdn2.microsoft.com/en-us/library/ms144259.aspx if using SQL2005. You
may also want to look at using SMO.
John
"Eng.Rana@.gmail.com" wrote:

> hi all,
> i want to develop some script to configure sql externally, can anyone
> tell me how can i do so' and wether this is possible or not'
> the type of configurations that i need, setting sa password, deleting
> guest account,Remove sample databases, Audit Login events, Restrict
> CmdExec rights to SysAdmins,...
> i want to develop a script to enforce the configurations above by
> executing this script
> any ideas'?
>|||thanx John
but actually i don want to do so while installation, i want to run such
a script to recfonfigure the already installed SQLs, to be secure
i'm using SQL 2000
John Bell wrote:[vbcol=seagreen]
> Hi
> Some of the things you are wanting to do may be configurable during the
> installation see
> http://msdn2.microsoft.com/en-us/library/ms144259.aspx if using SQL2005. Y
ou
> may also want to look at using SMO.
> John
> "Eng.Rana@.gmail.com" wrote:
>|||thanx
but isn't there any other way to do the same job'
Uri Dimant wrote:[vbcol=seagreen]
> Yep, you'll have to develop some code in T-SQL as well
>
> <Eng.Rana@.gmail.com> wrote in message
> news:1163936328.124164.100050@.m7g2000cwm.googlegroups.com...|||Have a .sql file containing the commands, which you kick off using SQLCMD.EX
E or OSQL.EXE?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<Eng.Rana@.gmail.com> wrote in message news:1163953498.340666.124840@.f16g2000cwb.googlegroups
.com...
> thanx
> but isn't there any other way to do the same job'
> Uri Dimant wrote:
>|||thanx Tibor
what if i want to take an exteranl args from users like the new sa
password for example
Tibor Karaszi wrote:[vbcol=seagreen]
> Have a .sql file containing the commands, which you kick off using SQLCMD.
EXE or OSQL.EXE?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <Eng.Rana@.gmail.com> wrote in message news:1163953498.340666.124840@.f16g20
00cwb.googlegroups.com...|||> what if i want to take an exteranl args from users like the new sa
> password for example
SQLCMD.EXE (shipped with 2005) has support for variables. In the script file
, you specify $(varname)
and when you run the script, you use the -v option to specify a value for a
variable. But it
definitely seems like you should provide the end-user with a proper small ap
p to do these changes.
Much more robust...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<Eng.Rana@.gmail.com> wrote in message news:1163957220.279868.20100@.e3g2000cwe.googlegroups.c
om...
> thanx Tibor
> what if i want to take an exteranl args from users like the new sa
> password for example
> Tibor Karaszi wrote:
>

Configuring SQL

hi all,
i want to develop some script to configure sql externally, can anyone
tell me how can i do so' and wether this is possible or not'
the type of configurations that i need, setting sa password, deleting
guest account,Remove sample databases, Audit Login events, Restrict
CmdExec rights to SysAdmins,...
i want to develop a script to enforce the configurations above by
executing this script
any ideas'?> the type of configurations that i need, setting sa password, deleting
> guest account,Remove sample databases, Audit Login events, Restrict
> CmdExec rights to SysAdmins,...
1) sp_password (setting sa password)
2) sp_dropsuer 'guest'
3) drop database 'dbname' (Remove sample databases)
4) Run sql server Profiler (Audit Login events)
5) Read "CmdExec jobs" in the BOL (Restrict CmdExec rights to SysAdmins),
sp_droprolemember system stored procedure
<Eng.Rana@.gmail.com> wrote in message
news:1163934268.329344.18750@.m73g2000cwd.googlegroups.com...
> hi all,
> i want to develop some script to configure sql externally, can anyone
> tell me how can i do so' and wether this is possible or not'
> the type of configurations that i need, setting sa password, deleting
> guest account,Remove sample databases, Audit Login events, Restrict
> CmdExec rights to SysAdmins,...
> i want to develop a script to enforce the configurations above by
> executing this script
> any ideas'?
>|||thanx for the reply :)
but how can i run these externally, shall i develope some code, using
.NET for example to call these stored procedures
or can i write some script to call them externally, all at once
Uri Dimant wrote:
> > the type of configurations that i need, setting sa password, deleting
> > guest account,Remove sample databases, Audit Login events, Restrict
> > CmdExec rights to SysAdmins,...
> 1) sp_password (setting sa password)
> 2) sp_dropsuer 'guest'
> 3) drop database 'dbname' (Remove sample databases)
> 4) Run sql server Profiler (Audit Login events)
> 5) Read "CmdExec jobs" in the BOL (Restrict CmdExec rights to SysAdmins),
> sp_droprolemember system stored procedure
>
> <Eng.Rana@.gmail.com> wrote in message
> news:1163934268.329344.18750@.m73g2000cwd.googlegroups.com...
> > hi all,
> >
> > i want to develop some script to configure sql externally, can anyone
> > tell me how can i do so' and wether this is possible or not'
> >
> > the type of configurations that i need, setting sa password, deleting
> > guest account,Remove sample databases, Audit Login events, Restrict
> > CmdExec rights to SysAdmins,...
> >
> > i want to develop a script to enforce the configurations above by
> > executing this script
> >
> > any ideas'?
> >|||Yep, you'll have to develop some code in T-SQL as well
<Eng.Rana@.gmail.com> wrote in message
news:1163936328.124164.100050@.m7g2000cwm.googlegroups.com...
> thanx for the reply :)
> but how can i run these externally, shall i develope some code, using
> .NET for example to call these stored procedures
> or can i write some script to call them externally, all at once
> Uri Dimant wrote:
>> > the type of configurations that i need, setting sa password, deleting
>> > guest account,Remove sample databases, Audit Login events, Restrict
>> > CmdExec rights to SysAdmins,...
>> 1) sp_password (setting sa password)
>> 2) sp_dropsuer 'guest'
>> 3) drop database 'dbname' (Remove sample databases)
>> 4) Run sql server Profiler (Audit Login events)
>> 5) Read "CmdExec jobs" in the BOL (Restrict CmdExec rights to SysAdmins),
>> sp_droprolemember system stored procedure
>>
>> <Eng.Rana@.gmail.com> wrote in message
>> news:1163934268.329344.18750@.m73g2000cwd.googlegroups.com...
>> > hi all,
>> >
>> > i want to develop some script to configure sql externally, can anyone
>> > tell me how can i do so' and wether this is possible or not'
>> >
>> > the type of configurations that i need, setting sa password, deleting
>> > guest account,Remove sample databases, Audit Login events, Restrict
>> > CmdExec rights to SysAdmins,...
>> >
>> > i want to develop a script to enforce the configurations above by
>> > executing this script
>> >
>> > any ideas'?
>> >
>|||Hi
Some of the things you are wanting to do may be configurable during the
installation see
http://msdn2.microsoft.com/en-us/library/ms144259.aspx if using SQL2005. You
may also want to look at using SMO.
John
"Eng.Rana@.gmail.com" wrote:
> hi all,
> i want to develop some script to configure sql externally, can anyone
> tell me how can i do so' and wether this is possible or not'
> the type of configurations that i need, setting sa password, deleting
> guest account,Remove sample databases, Audit Login events, Restrict
> CmdExec rights to SysAdmins,...
> i want to develop a script to enforce the configurations above by
> executing this script
> any ideas'?
>|||thanx John
but actually i don want to do so while installation, i want to run such
a script to recfonfigure the already installed SQLs, to be secure :)
i'm using SQL 2000
John Bell wrote:
> Hi
> Some of the things you are wanting to do may be configurable during the
> installation see
> http://msdn2.microsoft.com/en-us/library/ms144259.aspx if using SQL2005. You
> may also want to look at using SMO.
> John
> "Eng.Rana@.gmail.com" wrote:
> > hi all,
> >
> > i want to develop some script to configure sql externally, can anyone
> > tell me how can i do so' and wether this is possible or not'
> >
> > the type of configurations that i need, setting sa password, deleting
> > guest account,Remove sample databases, Audit Login events, Restrict
> > CmdExec rights to SysAdmins,...
> >
> > i want to develop a script to enforce the configurations above by
> > executing this script
> >
> > any ideas'?
> >
> >|||thanx :)
but isn't there any other way to do the same job'
Uri Dimant wrote:
> Yep, you'll have to develop some code in T-SQL as well
>
> <Eng.Rana@.gmail.com> wrote in message
> news:1163936328.124164.100050@.m7g2000cwm.googlegroups.com...
> > thanx for the reply :)
> > but how can i run these externally, shall i develope some code, using
> > .NET for example to call these stored procedures
> > or can i write some script to call them externally, all at once
> >
> > Uri Dimant wrote:
> >> > the type of configurations that i need, setting sa password, deleting
> >> > guest account,Remove sample databases, Audit Login events, Restrict
> >> > CmdExec rights to SysAdmins,...
> >>
> >> 1) sp_password (setting sa password)
> >> 2) sp_dropsuer 'guest'
> >> 3) drop database 'dbname' (Remove sample databases)
> >> 4) Run sql server Profiler (Audit Login events)
> >> 5) Read "CmdExec jobs" in the BOL (Restrict CmdExec rights to SysAdmins),
> >> sp_droprolemember system stored procedure
> >>
> >>
> >>
> >> <Eng.Rana@.gmail.com> wrote in message
> >> news:1163934268.329344.18750@.m73g2000cwd.googlegroups.com...
> >> > hi all,
> >> >
> >> > i want to develop some script to configure sql externally, can anyone
> >> > tell me how can i do so' and wether this is possible or not'
> >> >
> >> > the type of configurations that i need, setting sa password, deleting
> >> > guest account,Remove sample databases, Audit Login events, Restrict
> >> > CmdExec rights to SysAdmins,...
> >> >
> >> > i want to develop a script to enforce the configurations above by
> >> > executing this script
> >> >
> >> > any ideas'?
> >> >
> >|||Have a .sql file containing the commands, which you kick off using SQLCMD.EXE or OSQL.EXE?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<Eng.Rana@.gmail.com> wrote in message news:1163953498.340666.124840@.f16g2000cwb.googlegroups.com...
> thanx :)
> but isn't there any other way to do the same job'
> Uri Dimant wrote:
>> Yep, you'll have to develop some code in T-SQL as well
>>
>> <Eng.Rana@.gmail.com> wrote in message
>> news:1163936328.124164.100050@.m7g2000cwm.googlegroups.com...
>> > thanx for the reply :)
>> > but how can i run these externally, shall i develope some code, using
>> > .NET for example to call these stored procedures
>> > or can i write some script to call them externally, all at once
>> >
>> > Uri Dimant wrote:
>> >> > the type of configurations that i need, setting sa password, deleting
>> >> > guest account,Remove sample databases, Audit Login events, Restrict
>> >> > CmdExec rights to SysAdmins,...
>> >>
>> >> 1) sp_password (setting sa password)
>> >> 2) sp_dropsuer 'guest'
>> >> 3) drop database 'dbname' (Remove sample databases)
>> >> 4) Run sql server Profiler (Audit Login events)
>> >> 5) Read "CmdExec jobs" in the BOL (Restrict CmdExec rights to SysAdmins),
>> >> sp_droprolemember system stored procedure
>> >>
>> >>
>> >>
>> >> <Eng.Rana@.gmail.com> wrote in message
>> >> news:1163934268.329344.18750@.m73g2000cwd.googlegroups.com...
>> >> > hi all,
>> >> >
>> >> > i want to develop some script to configure sql externally, can anyone
>> >> > tell me how can i do so' and wether this is possible or not'
>> >> >
>> >> > the type of configurations that i need, setting sa password, deleting
>> >> > guest account,Remove sample databases, Audit Login events, Restrict
>> >> > CmdExec rights to SysAdmins,...
>> >> >
>> >> > i want to develop a script to enforce the configurations above by
>> >> > executing this script
>> >> >
>> >> > any ideas'?
>> >> >
>> >
>|||thanx Tibor :)
what if i want to take an exteranl args from users like the new sa
password for example
Tibor Karaszi wrote:
> Have a .sql file containing the commands, which you kick off using SQLCMD.EXE or OSQL.EXE?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <Eng.Rana@.gmail.com> wrote in message news:1163953498.340666.124840@.f16g2000cwb.googlegroups.com...
> > thanx :)
> > but isn't there any other way to do the same job'
> >
> > Uri Dimant wrote:
> >> Yep, you'll have to develop some code in T-SQL as well
> >>
> >>
> >>
> >> <Eng.Rana@.gmail.com> wrote in message
> >> news:1163936328.124164.100050@.m7g2000cwm.googlegroups.com...
> >> > thanx for the reply :)
> >> > but how can i run these externally, shall i develope some code, using
> >> > .NET for example to call these stored procedures
> >> > or can i write some script to call them externally, all at once
> >> >
> >> > Uri Dimant wrote:
> >> >> > the type of configurations that i need, setting sa password, deleting
> >> >> > guest account,Remove sample databases, Audit Login events, Restrict
> >> >> > CmdExec rights to SysAdmins,...
> >> >>
> >> >> 1) sp_password (setting sa password)
> >> >> 2) sp_dropsuer 'guest'
> >> >> 3) drop database 'dbname' (Remove sample databases)
> >> >> 4) Run sql server Profiler (Audit Login events)
> >> >> 5) Read "CmdExec jobs" in the BOL (Restrict CmdExec rights to SysAdmins),
> >> >> sp_droprolemember system stored procedure
> >> >>
> >> >>
> >> >>
> >> >> <Eng.Rana@.gmail.com> wrote in message
> >> >> news:1163934268.329344.18750@.m73g2000cwd.googlegroups.com...
> >> >> > hi all,
> >> >> >
> >> >> > i want to develop some script to configure sql externally, can anyone
> >> >> > tell me how can i do so' and wether this is possible or not'
> >> >> >
> >> >> > the type of configurations that i need, setting sa password, deleting
> >> >> > guest account,Remove sample databases, Audit Login events, Restrict
> >> >> > CmdExec rights to SysAdmins,...
> >> >> >
> >> >> > i want to develop a script to enforce the configurations above by
> >> >> > executing this script
> >> >> >
> >> >> > any ideas'?
> >> >> >
> >> >
> >|||> what if i want to take an exteranl args from users like the new sa
> password for example
SQLCMD.EXE (shipped with 2005) has support for variables. In the script file, you specify $(varname)
and when you run the script, you use the -v option to specify a value for a variable. But it
definitely seems like you should provide the end-user with a proper small app to do these changes.
Much more robust...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<Eng.Rana@.gmail.com> wrote in message news:1163957220.279868.20100@.e3g2000cwe.googlegroups.com...
> thanx Tibor :)
> what if i want to take an exteranl args from users like the new sa
> password for example
> Tibor Karaszi wrote:
>> Have a .sql file containing the commands, which you kick off using SQLCMD.EXE or OSQL.EXE?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> <Eng.Rana@.gmail.com> wrote in message
>> news:1163953498.340666.124840@.f16g2000cwb.googlegroups.com...
>> > thanx :)
>> > but isn't there any other way to do the same job'
>> >
>> > Uri Dimant wrote:
>> >> Yep, you'll have to develop some code in T-SQL as well
>> >>
>> >>
>> >>
>> >> <Eng.Rana@.gmail.com> wrote in message
>> >> news:1163936328.124164.100050@.m7g2000cwm.googlegroups.com...
>> >> > thanx for the reply :)
>> >> > but how can i run these externally, shall i develope some code, using
>> >> > .NET for example to call these stored procedures
>> >> > or can i write some script to call them externally, all at once
>> >> >
>> >> > Uri Dimant wrote:
>> >> >> > the type of configurations that i need, setting sa password, deleting
>> >> >> > guest account,Remove sample databases, Audit Login events, Restrict
>> >> >> > CmdExec rights to SysAdmins,...
>> >> >>
>> >> >> 1) sp_password (setting sa password)
>> >> >> 2) sp_dropsuer 'guest'
>> >> >> 3) drop database 'dbname' (Remove sample databases)
>> >> >> 4) Run sql server Profiler (Audit Login events)
>> >> >> 5) Read "CmdExec jobs" in the BOL (Restrict CmdExec rights to SysAdmins),
>> >> >> sp_droprolemember system stored procedure
>> >> >>
>> >> >>
>> >> >>
>> >> >> <Eng.Rana@.gmail.com> wrote in message
>> >> >> news:1163934268.329344.18750@.m73g2000cwd.googlegroups.com...
>> >> >> > hi all,
>> >> >> >
>> >> >> > i want to develop some script to configure sql externally, can anyone
>> >> >> > tell me how can i do so' and wether this is possible or not'
>> >> >> >
>> >> >> > the type of configurations that i need, setting sa password, deleting
>> >> >> > guest account,Remove sample databases, Audit Login events, Restrict
>> >> >> > CmdExec rights to SysAdmins,...
>> >> >> >
>> >> >> > i want to develop a script to enforce the configurations above by
>> >> >> > executing this script
>> >> >> >
>> >> >> > any ideas'?
>> >> >> >
>> >> >
>> >
>

Configuring SQL

hi all,

i want to develop some script to configure sql externally, can anyone
tell me how can i do so?? and wether this is possible or not??

the type of configurations that i need, setting sa password, deleting
guest account,Remove sample databases, Audit Login events, Restrict
CmdExec rights to SysAdmins,...

i want to develop a script to enforce the configurations above by
executing this script

any ideas???Have you considered using the Script-Task in the SSIS-package? AFAIK you
can access all functions there and write your Script in VB.NET code.

--
Benedikt Ries
----------------------
Benedikt Ries's Profile: http://www.dbtalk.net/m1098
View this thread: http://www.dbtalk.net/t345220|||Thanx Benedikt :),
plz note i'm using SQL server 2000

any other ideas??

Benedikt Ries wrote:

Quote:

Originally Posted by

Have you considered using the Script-Task in the SSIS-package? AFAIK you
can access all functions there and write your Script in VB.NET code.
>
>
--
Benedikt Ries
----------------------
Benedikt Ries's Profile: http://www.dbtalk.net/m1098
View this thread: http://www.dbtalk.net/t345220

|||Create a batch file that will use OSQL or ISQL, and run all script you
want.
something like :

SET SERVERNAME=XYZ
SET DBNAME=ABC
SET USERNAME=ABC
SET PSW=ABC

ISQLW -U%USERNAME% -P%PSW% -S%SERVERNAME% -d%DBNAME%
-ic:\temp\script1.SQL -oLOGFILE.LOG -FA -n
TYPE LOGFILE.LOG >FULLLOG.LOG

ISQLW -U%USERNAME% -P%PSW% -S%SERVERNAME% -d%DBNAME%
-ic:\temp\script3.SQL -oLOGFILE.LOG -FA -n
TYPE LOGFILE.LOG >FULLLOG.LOG

Eng.Rana@.gmail.com wrote:

Quote:

Originally Posted by

Thanx Benedikt :),
plz note i'm using SQL server 2000
>
any other ideas??
>
>
Benedikt Ries wrote:

Quote:

Originally Posted by

Have you considered using the Script-Task in the SSIS-package? AFAIK you
can access all functions there and write your Script in VB.NET code.

--
Benedikt Ries
----------------------
Benedikt Ries's Profile: http://www.dbtalk.net/m1098
View this thread: http://www.dbtalk.net/t345220

Configuring SIS in a Cluster problem

I am attempting to configure SIS in a clustered environment using the
instructions found at http://msdn2.microsoft.com/en-us/library/ms345193.aspx.
I have added the required dependancies to a new generic resource in
the Cluster Adminstration screen and it is now asking me for DHCP
Service Parameters such as Database Path; Audit File Path, Backup
Path. These are not discussed in the instructions in the instructions
and I can't find any info on this page. Can anyone advise what
information the wizard is looking for here?
My SysAdmin tells me we are getting DHCP from Novel, if that helps.
On Dec 10, 10:11 am, Fayven Wren <FayvenW...@.gmail.com> wrote:
> I am attempting to configure SIS in a clustered environment using the
> instructions found athttp://msdn2.microsoft.com/en-us/library/ms345193.aspx.
> I have added the required dependancies to a new generic resource in
> the Cluster Adminstration screen and it is now asking me for DHCP
> Service Parameters such as Database Path; Audit File Path, Backup
> Path. These are not discussed in the instructions in the instructions
> and I can't find any info on this page. Can anyone advise what
> information the wizard is looking for here?
> My SysAdmin tells me we are getting DHCP from Novel, if that helps.
My Bad. Misread the instructions and did not specify the Service Type
as "Generic Service".

configuring replication sql 2005 express edition

Hello all,

We have 2 sites . each one has sql 2005 express edition .

is it possible to configure replication between those 2 sql servers for failover purposes ?

ThanksSort of. You should use log shipping for something like this. Note that SQL Server Express does not support replication publishing, ie you can't use merge replication to publish database on a SQL Express installation. You can make them subscribers however.

Nor can you use the log shipping wizard which ships in SQL Server Standard and above.

You will have to roll your own log shipping topology and you will have to do manual failover and redirect your clients to the failover server.

Configuring Replication

When I try to configure using enterprise manager, at the last step, This
error message raised..
Error 18483: Could not connect to server 'GKBT' because 'distributor_admin'
is not defined as a remote login at the server
What s the problem?
Thank you
Thank you,
Registration name was '192.168.1.200' (Server IP), after your message, I ve
changed the name to server name 'GKBT', but this time error message is ;
Error 21112 - '-polling interval' is not a valid parameter for the log
readere agent
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:774001c4ce44$fd0de220$a601280a@.phx.gbl...
> If you are using an IP address to configure replication
> over non-trusted domains, you'll need to use the client
> network utility to configure an alias.
> Alternatively this could be a naming issue:
> This is usually a naming issue.
> Try:
> Use Master
> go
> Select @.@.Servername
> This should return your current server name but if it
> returns NULL then try:
> Use Master
> go
> Sp_DropServer 'ServerOldName'
> GO
> Use Master
> go
> Sp_Addserver 'ServerNewName', 'local'
> GO
> Stop and Start SQL Services
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Does replication work to any other server?
If not remove replication and reinstall it.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"BonGee" <Bongeeeee@.dotcom.com> wrote in message
news:OPHl6njzEHA.3416@.TK2MSFTNGP09.phx.gbl...
> When I try to configure using enterprise manager, at the last step, This
> error message raised..
> Error 18483: Could not connect to server 'GKBT' because
> 'distributor_admin'
> is not defined as a remote login at the server
> What s the problem?
> Thank you
>
|||PollingInterval is all one word, but don't change it on
the command line properties - leave those for parameters
that aren't included in the profile ie you can just put a
numerical value in a custom profile.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thank you but I installed MS 2000 2 hours before
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eirUXekzEHA.1296@.TK2MSFTNGP10.phx.gbl...
> Does replication work to any other server?
> If not remove replication and reinstall it.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> Now available for purchase at:
> http://www.nwsu.com/0974973602.html
> "BonGee" <Bongeeeee@.dotcom.com> wrote in message
> news:OPHl6njzEHA.3416@.TK2MSFTNGP09.phx.gbl...
>
|||By installing/removing replication, I mean going to the menu option in SQL
Server Enterprise Manager and selecting Tools, Replication, Disable
Replication to remove it, and then select Tools, Replication, Configure
Replicaiton to reinstall it.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"BonGee" <Bongeeeee@.dotcom.com> wrote in message
news:OKVrOikzEHA.1396@.tk2msftngp13.phx.gbl...
> Thank you but I installed MS 2000 2 hours before
>
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:eirUXekzEHA.1296@.TK2MSFTNGP10.phx.gbl...
>

Configuring Remote SMTP for Reporting Server

I am using the SQL server 2000 along with Microsoft Reporting Services. I need to configure SQLReporting services for sending reports through emails using subscription

services. I don't have any SMTP server located in my local network or on Reporting server. We are using external SMTP server for sending & receiving mails through outlook express. How to configure the RSReportServer.config file for the same?

If we refer documentation available in Reporting Service Books Online, it states that we

can configure using SMTPAuthenticate settings by using "SENDUSERNAME" & "SENDPASSWORD" in rsconfig file. But If We Refer the MSDN online it states SMTPAuthenticate authorization is not supported.

Please help us in matter to solve the problem. We are unable to send mails using reporting service by using the settings stated in the Reporting Service Books Online.

It gives error "The e-mail address of one or more recipients is not valid" due to relaying denied by mail server which requires authentication.

Please solve the following problems.

1. Whether it is possible to use SMTP server outside the network or not?

2. If yes what is the method of configuring SMTP services?

3. How can we send username & password to authenticate the user?

4. Send us sample RSReportServer.config if possible for the same.

Thanking you

I suppose no one wants to answer my question or no one knows the answer ? Well after the research i come to know that the my remote SMTP server do not allow relaying on server. So enabling relaying can solve the problem. But it can create SPAM mail problems.

I d't fine any method to send username & password to smtp server.Any body knows how to send user authorization & password to SMTP server for reporting service mails. ?

|||

Hi,

I saw your post today when I was doing a little bit reseach about this problem. Because my server was keep giving me the same reply. I was able to sent e-mail someone in our domain but not the outside world.

Luckly I found the answer. You need to add some authentication details to send an e-mail.

Here is my SMTP e-mail function. I am sure you will spot the missing codes immediately

Public Function sendMail(ByVal strFromEmail As String, ByVal strToEmail As String, ByVal strSubject As String, ByVal strMessage As String) As Boolean

Try

Dim msg As New System.Net.Mail.MailMessage

Dim addressFrom As New System.Net.Mail.MailAddress(strFromEmail)

Dim addressTo As New System.Net.Mail.MailAddress(strToEmail)

msg.From = addressFrom

msg.To.Add(addressTo)

msg.Subject = strSubject

msg.Body = strMessage

Dim smtp As System.Net.Mail.SmtpClient = New System.Net.Mail.SmtpClient

smtp.Host = "MAIL HOST"

smtp.Port = 25

Dim basicAuthenticationInfo As New System.Net.NetworkCredential("USERNAME", "PASSWORD")

smtp.UseDefaultCredentials = False

smtp.Credentials = basicAuthenticationInfo

'smtp.Attachments.Add(New System.Web.Mail.MailAttachment("c:\pic1.jpg"))

smtp.Send(msg)

Catch ex As Exception

MsgBox(ex.Message)

Debug.Print(ex.Message)

End Try

End Function

Configuring Remote SMTP for Reporting Server

I am using the SQL server 2000 along with Microsoft Reporting Services. I need to configure SQLReporting services for sending reports through emails using subscription

services. I don't have any SMTP server located in my local network or on Reporting server. We are using external SMTP server for sending & receiving mails through outlook express. How to configure the RSReportServer.config file for the same?

If we refer documentation available in Reporting Service Books Online, it states that we

can configure using SMTPAuthenticate settings by using "SENDUSERNAME" & "SENDPASSWORD" in rsconfig file. But If We Refer the MSDN online it states SMTPAuthenticate authorization is not supported.

Please help us in matter to solve the problem. We are unable to send mails using reporting service by using the settings stated in the Reporting Service Books Online.

It gives error "The e-mail address of one or more recipients is not valid" due to relaying denied by mail server which requires authentication.

Please solve the following problems.

1. Whether it is possible to use SMTP server outside the network or not?

2. If yes what is the method of configuring SMTP services?

3. How can we send username & password to authenticate the user?

4. Send us sample RSReportServer.config if possible for the same.

Thanking you

I suppose no one wants to answer my question or no one knows the answer ? Well after the research i come to know that the my remote SMTP server do not allow relaying on server. So enabling relaying can solve the problem. But it can create SPAM mail problems.

I d't fine any method to send username & password to smtp server.Any body knows how to send user authorization & password to SMTP server for reporting service mails. ?

|||

Hi,

I saw your post today when I was doing a little bit reseach about this problem. Because my server was keep giving me the same reply. I was able to sent e-mail someone in our domain but not the outside world.

Luckly I found the answer. You need to add some authentication details to send an e-mail.

Here is my SMTP e-mail function. I am sure you will spot the missing codes immediately

Public Function sendMail(ByVal strFromEmail As String, ByVal strToEmail As String, ByVal strSubject As String, ByVal strMessage As String) As Boolean

Try

Dim msg As New System.Net.Mail.MailMessage

Dim addressFrom As New System.Net.Mail.MailAddress(strFromEmail)

Dim addressTo As New System.Net.Mail.MailAddress(strToEmail)

msg.From = addressFrom

msg.To.Add(addressTo)

msg.Subject = strSubject

msg.Body = strMessage

Dim smtp As System.Net.Mail.SmtpClient = New System.Net.Mail.SmtpClient

smtp.Host = "MAIL HOST"

smtp.Port = 25

Dim basicAuthenticationInfo As New System.Net.NetworkCredential("USERNAME", "PASSWORD")

smtp.UseDefaultCredentials = False

smtp.Credentials = basicAuthenticationInfo

'smtp.Attachments.Add(New System.Web.Mail.MailAttachment("c:\pic1.jpg"))

smtp.Send(msg)

Catch ex As Exception

MsgBox(ex.Message)

Debug.Print(ex.Message)

End Try

End Function