connect to server name 2005!

First time I am using sql server 2005.
What is the default server name' I can not see anything in managment
studio.
whenever i tried to connect OR create database through SQL sever
Management studio, it asked me:
server type: (here i select Database Engine)
server Name : ( '')
Authentication : which one I have to use? (Windows Authentiction is by
default, another is SQL server Authentication,)...
I don't know what to do with server name . Please advise.Hi,
please do not mulitpost, answered in public.sqlserver
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
--

connect to server name 2005!

First time I am using sql server 2005.
What is the default server name' I can not see anything in managment
studio.
whenever i tried to connect OR create database through SQL sever
Management studio, it asked me:
server type: (here i select Database Engine)
server Name : ( '')
Authentication : which one I have to use? (Windows Authentiction is by
default, another is SQL server Authentication,)...
I don't know what to do with server name . Please advise.Hi,
please do not mulitpost, answered in public.sqlserver
HTH, jens Suessmeyer.
--
http://www.sqlserver2005.de
--sqlsql

Connect to a DataSet Variable as a Source?

Hello. I’m new to SSIS. This forum and Kirk Haselden’s book are my teachers. I’m having a hard time grasping something basic to get started defining a set of packages to automate the ETL process, however, and perhaps I’m simply misunderstanding the best practices of SSIS.

I have source data in two different transactional databases, and use OleDb connection managers (and OleDb Source components in the Data Flow) to extract the data. I use a Script Task and several Lookup widgets in the Data Flow to transform the data, and output each to two different package-scope DataSet variables.

How do I join these two datasets in a third Data Flow task for loading into my data warehouse? It seems I can iterate through them in the Control Flow, but I can’t write a query against them in the Data Flow, since there is no connection manager that allows me to “connect” to a package-level variable. Should I instead be storing my extracted, transformed data in temporary database tables, and then joining these to do the final load?

Any advice greatly appreciated. Thanks in advance.

MilwaukeeCharlie wrote:

Hello. I’m new to SSIS. This forum and Kirk Haselden’s book are my teachers. I’m having a hard time grasping something basic to get started defining a set of packages to automate the ETL process, however, and perhaps I’m simply misunderstanding the best practices of SSIS.

I have source data in two different transactional databases, and use OleDb connection managers (and OleDb Source components in the Data Flow) to extract the data. I use a Script Task and several Lookup widgets in the Data Flow to transform the data, and output each to two different package-scope DataSet variables.

How do I join these two datasets in a third Data Flow task for loading into my data warehouse? It seems I can iterate through them in the Control Flow, but I can’t write a query against them in the Data Flow, since there is no connection manager that allows me to “connect” to a package-level variable. Should I instead be storing my extracted, transformed data in temporary database tables, and then joining these to do the final load?

Any advice greatly appreciated. Thanks in advance.

Charlie,

You're absolutely correct, there is no source adapter for these and with good reason too.

There is a workaround though:

Recordsets instead of raw files

(http://blogs.conchango.com/jamiethomson/archive/2006/01/04/SSIS_3A00_-Recordsets-instead-of-raw-files.aspx)

Another option (and the one I would use for performance reasons as explained here: http://blogs.conchango.com/jamiethomson/archive/2006/06/28/SSIS_3A00_-Comparing-performance-of-a-raw-file-against-a-recordset-destination.aspx) is to use raw files

By the way, the correct nomenclature is "components", not "widgets"

Good luck!

-Jamie

Connect timeout?

Hi all
I set the connection timeout property in my connection string but it dosen't
effect.
my connection time out in 30 sec..I set it to above 30
but it dosen't effect..
hi,
perspolis wrote:
> Hi all
> I set the connection timeout property in my connection string but it
> dosen't effect.
> my connection time out in 30 sec..I set it to above 30
> but it dosen't effect..
I usually get the required result(s)..
see http://www.connectionstrings.com/, "read more" frame,
Connect Timeout
-or-
Connection Timeout
, thus,
connection_string = "....;Connection Timeout = n;"
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply
|||I know how can I use it..but it dosen't have any impact in connection
string..
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:4pukiiFkoabnU1@.individual.net...
> hi,
> perspolis wrote:
> I usually get the required result(s)..
> see http://www.connectionstrings.com/, "read more" frame,
> Connect Timeout
> -or-
> Connection Timeout
> , thus,
> connection_string = "....;Connection Timeout = n;"
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
|||hi,
perspolis wrote:
> I know how can I use it..but it dosen't have any impact in connection
> string..
have you read Stefan Berglund answer in other ng?
(BTW, please do not multipost, crosspost instead, if pertinent and required
:D)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply

Connect time very slow

Hi,
I've been using the sql server jdbc driver for quite a while. Out of the
blue my connect times are huge, 15-25 seconds. I've written the following
test code:
System.out.println("connecting");
Class.forName("com.microsoft.jdbc.sqlserver.SQLSer verDriver");
Connection con =
DriverManager.getConnection("jdbc:microsoft:sqlser ver://devserver1:1433;Data
baseName=eipp0053","sa","password");
System.out.println("connected");
I thought it may have something to do with network stuf, but if I run query
analyser or similar it connects straight through no problems. Anyone got
any ideas?
Chris.
"Chris Warr" <cwarr@.--no-spam--.labyrinth.net.au> wrote in message
news:1086133910.48572@.proxy.nec.com.au...
> Hi,
> I've been using the sql server jdbc driver for quite a while. Out of the
> blue my connect times are huge, 15-25 seconds. I've written the following
> test code:
> System.out.println("connecting");
> Class.forName("com.microsoft.jdbc.sqlserver.SQLSer verDriver");
> Connection con =
>
DriverManager.getConnection("jdbc:microsoft:sqlser ver://devserver1:1433;Data
> baseName=eipp0053","sa","password");
> System.out.println("connected");
> I thought it may have something to do with network stuf, but if I run
query
> analyser or similar it connects straight through no problems. Anyone got
> any ideas?
> Chris.
>
Forgot to mention, my enviroment is:
Windows 2000 server Talking to Sql Server 2000
Sun Java 1.3.1_04
|||> >[vbcol=seagreen]
> query
got
> Forgot to mention, my enviroment is:
> Windows 2000 server Talking to Sql Server 2000
> Sun Java 1.3.1_04
>
Never mind, I've discovered the wonderful jtds driver, converted my code
over in no time and the connection is instantanious. Goodbye MS driver.
Chris.

Connect SSRS to MS Access db that has User-Level Security

Hello Everyone,
I have an Access database that i set up some time ago and that is still in
use by employees. The database was set up using user-level security. The
database is seperated, one- the "back end", named **be.mdb- housing the
tables and some queries. The other- **.mdb- has all the forms, modules and
other queries. The back end is on a shared file server, and each user has the
front end on thier local machine.
I use the Report Wizard to setup the data source connection, which is ODBC,
and permissions. I can preview it in Report Designer fine. Once the report is
published to the Report Manager however, I get an error telling me that no
connection to datasource can be established because either i have no
permissions, the workgroup information file can not be found or someone else
is using the file.
When I setup up the dsn, i made sure to include the WIF in the string- named
secure.mdw. However I'm stumped as to my failure to connect. Can anyone give
me some guidance on how to properly setup connection from SSRS to an Access
datbase that has user-level security?
Many thanks.I'd just move it to SQL Server.. Honestly; I've been through a ton of
migrations over the years-- moving to SQL Server _NOW_ instead of
later can save you a lot of headaches.
I mean.. the front end ; it should be easy to move to an Access Data
Project-- simplify the database side before worrying about the
reports.
-Aaron
On Mar 21, 1:49=A0pm, Damon Johnson
<DamonJohn...@.discussions.microsoft.com> wrote:
> Hello Everyone,
> I have an Access database that i set up some time ago and that is still in=
> use by employees. The database was set up using user-level security. The
> database is seperated, one- the "back end", named **be.mdb- housing the
> tables and some queries. The other- **.mdb- has all the forms, modules and=
> other queries. The back end is on a shared file server, and each user has =the
> front end on thier local machine.
> I use the Report Wizard to setup the data source connection, which is ODBC=,
> and permissions. I can preview it in Report Designer fine. Once the report= is
> published to the Report Manager however, I get an error telling me that no=
> connection to datasource can be established because either i have no
> permissions, the workgroup information file can not be found or someone el=se
> is using the file.
> When I setup up the dsn, i made sure to include the WIF in the string- nam=ed
> secure.mdw. However I'm stumped as to my failure to connect. Can anyone gi=ve
> me some guidance on how to properly setup connection from SSRS to an Acces=s
> datbase that has user-level security?
> Many thanks.

connect SQL server 2000 with c#.net .....?Full code

Hello masters,

help me yaar

i am using dotnet 2003 and SqL SERVER 2000. BUT UNABLE TO CONNECT DATABASE using dataAdaptor(design time ) or sqlconnection any can help me

gs

whats the error?

lets see the connection string.

make an empty text file called "c:\test.udl" - double click it and try to build a SQL Ole Db Provider datalink. . . can you get that to work?

Are the TCP protocols enabled in your machines client network settings and in the servers network settings?

|||Guess you don′t have the right connection string, look at www.connectionstrings.com for appropiate connection strings.

HTH, jens Suessmeyer.|||

hi i am using this code it dose not show any error as well as no output... please check it...

string conn = ("Data Source=localhost;"+

"Initial Catalog=gstest;"+

"User ID=sa;"+

"Password=logic;");

SqlConnection con = new SqlConnection();

con.ConnectionString = conn;

SqlDataAdapter da = new SqlDataAdapter("select * from tb1",con);

DataSet ds = new DataSet();

da.Fill(ds,"tb");

dataGrid1.DataSource = ds.DefaultViewManager;

|||

hello i got this error now,

what to do?

An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll

Additional information: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

|||

If this is a web project (?!) you have to rebind the grid to the data

dataGrid1.DataBind()

HTH, jens Suessmeyer.

|||

what does this do:

try
{
DataSet ds = new DataSet();
string conn = "Data Source=localhost;Initial Catalog=gstest;User ID=sa;Password=logic;";
using(SqlConnection con = new SqlConnection(conn))
{
using(SqlDataAdapter da = new SqlDataAdapter("select * from tb1",con))
{
da.Fill(ds);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

|||

hi master

it display...

Sql server dose not exist or access denied

but my sql server is running ......?

|||The using statement is doing garbage collection after the scope is funished. Fills your dataset like the first statement.

HTH, Jens Suessmeyer.|||

Jens Suessmeyer wrote:

Guess you don′t have the right connection string, look at www.connectionstrings.com for appropiate connection strings.

HTH, jens Suessmeyer.

the connection string is properly formed. whether that user/pw is correct and has permissions is another story.

Is the sql server on your development machine?

on the client, check that the TCP protocols are enabled using the Client Network Utility (cliconfig.exe) and on the server there is the Server Network Utility (svrnetcn.exe)

got windows firewall on? might try turning that off.

look at services control panel applet connected to the server.

does it show:

MSSQL or MSSQLSERVER

is it running?

|||Like it says "..or access denied". Whether you are not a default instance, then you have to suffix the instance name after the servername like localhost/instancename or you use a different port than the standard port then you have to add the port after the instancename servername/instance,Port ot you have a security problem, that the password is not valid for the sa account.

HTH, jens Suessmeyer.|||

still suffring

MSSQLSERVER is running on my pc i have also turn off the fire wall.

but the error is the same.

i like to know that after installing sql server is any process to configure with dotnet2003

if there is any pls inform me.....

pls.............

|||

Can you use integrated authentication ? If so (and you are in the adminstrative group, which should be server administrator by default int the installation) try using instead of UserID=yadayada;Password=blabla --> "Integrated Security=true"

HTH, Jens Suessmeyer-

|||

no, not really. . . did you check these:

Client Network Utility (cliconfig.exe) and Server Network Utility (svrnetcn.exe)

to make sure the tcp protocols are started?

did you make that empty udl file to check if Datalinks could connect?

|||

i am working on windows 2000 prof O/S

i have just downloaded the sqlserver 2000 form the net for installing this i have used the command in dos prompt...

C:\Program Files\Microsoft Visual Studio .NET 2003\Setup\MSDE\setup sapwd=logic securitymode=sql

after this sql server is installed in my computer and then i have downloded the Database manager(trial verson) to create the database and the tabels.

using this database and the tabels are created but

i am not able to connecte using dotnet2003

and pls tell me how to check the...

Client Network Utility (cliconfig.exe) and Server Network Utility (svrnetcn.exe)

to make sure the tcp protocols are started?

Confusion on Time Intelligence

Hi, all experts here,

Thank you for your kind attention.

Just really confused about Time Intelligence. Would please any experts here shed me any light on Time Intelligence? What are the main concern or benefits of creating Time Intelligence? Any disavantages of using it?

Thank you very much in advance for your kind advices and help for that and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

Hello Helen!

Here is a link to Moshas Blog about Time Intelligence: http://www.sqljunkies.com/WebLog/mosha/archive/2006/10/25/time_calculations_parallelperiod.aspx

The are also additional links to more information in that Blog entry.

And Chris Webb have written a few posts on this subject here: http://cwebbbi.spaces.live.com/

HTH

Thomas Ivarsson

Conflict Viewer hangs

Hello, All!
MS SQL 2k EE SP3a, merge replication.
After long time Conflict Viewer began to hang when viewing conflicts on some
articles (not on all). There is no waiting locks. Workload is minimal.
What's wrong?
Thanx in advance.
I've run it under debugger and found that it runs an infinite loop in the
sqloledb.dll
No commands sent to server.
Guys from MS - whats wrong?
"Ray D" wrote:

> Hello, All!
> MS SQL 2k EE SP3a, merge replication.
> After long time Conflict Viewer began to hang when viewing conflicts on some
> articles (not on all). There is no waiting locks. Workload is minimal.
> What's wrong?
> Thanx in advance.

conflict as the same row being changed at the same time by two sites

Hello
I made merge replication between 2 machines successfully.
BUT,
when a user on each machine insert a new row in the same table in the same
time,the insert for the publisher wins and the insert for subscriber
deleted.
I need to keep the two inserts in the database.
And that also happen with the update.
Thanks alot
Tamer,
it sounds like you need to partition the inserts, so an insert on the
publisher will have a different id to an insert on the subscriber. You can
do this in various ways, but probably the most common is to use identity
ranges to ensure the values don't overlap.
HTH,
Paul Ibison

Configuring Text Log File Path in dtxConfig

Hi,

I am having trouble configuring the log file path in dtsconfig. I don't want to keep changing the log file path every time I change environments.

Here are the parameters.

<Configuration ConfiguredType="Property" Path="\Package.LogProviders[SSIS log provider for Text files].Properties[ConfigString]" ValueType="String">
<ConfiguredValue>SalesForceConnectLog</ConfiguredValue>
</Configuration>

<Configuration ConfiguredType="Property" Path="\Package.LogProviders[SSIS log provider for Text files].Properties[Name]" ValueType="String">
<ConfiguredValue>SSIS log provider for Text files</ConfiguredValue>
</Configuration>

I tried to enter the path on [ConfigString] but it didn't work.

Any Help is appreciated

Gulden

You don't update the log provider, you update the connection manager for that log provider.|||

You are absolutely right. Your email also reminded me why I had ruled that out. It was a problem with logging to the same file from two different packages. I went back and corrected that.

Thanks for your answer..

Configuring Environment for first time

Each time I start of SQL Server Management Studio, I get the following message "Microsoft SQL Server Management Studio configuring environment for first time".

I had a simiiliar message with Visual Studio 2005 and fixed it by setting the setting to look on local disk drive. I cannot find a similiar setting in SQL Server 2005.

Any suggestions on how to resolve?

mwharton - I have the same question. Did you find an answer anywhere?

Harold

Configuring Environment for first time

Each time I start of SQL Server Management Studio, I get the following message "Microsoft SQL Server Management Studio configuring environment for first time".

I had a simiiliar message with Visual Studio 2005 and fixed it by setting the setting to look on local disk drive. I cannot find a similiar setting in SQL Server 2005.

Any suggestions on how to resolve?

mwharton - I have the same question. Did you find an answer anywhere?

Harold

Configure Server for Email Delivery

I am having trouble getting a report emailed for the first time.
The timed subscription has been set. I have updated the ReportServer.config
file to include the ip of the exchange server along with port number although
im not sure where to enter a password. The IT guys are making sure that the
exchange server will accept smtp requests from other servers. My question is
what is the best method to troubleshoot & is there anything gleeming that i
am missing. ThanksI have noted that the sql server agent has a job logged & shows suceeded when
last run but I have recieved any emails. I have also noted a job in the
process info that has a status of sleeping. Event log shows nothing
"Tango" wrote:
> I am having trouble getting a report emailed for the first time.
> The timed subscription has been set. I have updated the ReportServer.config
> file to include the ip of the exchange server along with port number although
> im not sure where to enter a password. The IT guys are making sure that the
> exchange server will accept smtp requests from other servers. My question is
> what is the best method to troubleshoot & is there anything gleeming that i
> am missing. Thanks|||Can anyone help, please. Maybe a link to a ReportServer.config that is
successfully emailing reports might help.
Thankyou
"Tango" wrote:
> I have noted that the sql server agent has a job logged & shows suceeded when
> last run but I have recieved any emails. I have also noted a job in the
> process info that has a status of sleeping. Event log shows nothing
> "Tango" wrote:
> > I am having trouble getting a report emailed for the first time.
> > The timed subscription has been set. I have updated the ReportServer.config
> > file to include the ip of the exchange server along with port number although
> > im not sure where to enter a password. The IT guys are making sure that the
> > exchange server will accept smtp requests from other servers. My question is
> > what is the best method to troubleshoot & is there anything gleeming that i
> > am missing. Thanks|||Tango,
Did you ever find out an answer to this? If so could you please share it?
"Tango" wrote:
> Can anyone help, please. Maybe a link to a ReportServer.config that is
> successfully emailing reports might help.
> Thankyou
> "Tango" wrote:
> > I have noted that the sql server agent has a job logged & shows suceeded when
> > last run but I have recieved any emails. I have also noted a job in the
> > process info that has a status of sleeping. Event log shows nothing
> >
> > "Tango" wrote:
> >
> > > I am having trouble getting a report emailed for the first time.
> > > The timed subscription has been set. I have updated the ReportServer.config
> > > file to include the ip of the exchange server along with port number although
> > > im not sure where to enter a password. The IT guys are making sure that the
> > > exchange server will accept smtp requests from other servers. My question is
> > > what is the best method to troubleshoot & is there anything gleeming that i
> > > am missing. Thanks|||It is notoriously difficult to get the subscriptions to work, I spent a week
configuring a production server trying to do this and gave up, I have the
feeling you need to re-install RS using different accounts/settings, which in
my case wasn't an option. I ended up coding a small windows service that
downloaded the report through a crafted URL and emailed it based on a
schedule in a table. It actually took less to code that snippet than to
configure the much glorified data driven subscription feature of RS.
Microsoft shouldn't be in such a hurry to advertise features that won't even
work in plain vanilla, no frills install out of the box.
Regards,
Tzepesh
"Tango" wrote:
> Can anyone help, please. Maybe a link to a ReportServer.config that is
> successfully emailing reports might help.
> Thankyou
> "Tango" wrote:
> > I have noted that the sql server agent has a job logged & shows suceeded when
> > last run but I have recieved any emails. I have also noted a job in the
> > process info that has a status of sleeping. Event log shows nothing
> >
> > "Tango" wrote:
> >
> > > I am having trouble getting a report emailed for the first time.
> > > The timed subscription has been set. I have updated the ReportServer.config
> > > file to include the ip of the exchange server along with port number although
> > > im not sure where to enter a password. The IT guys are making sure that the
> > > exchange server will accept smtp requests from other servers. My question is
> > > what is the best method to troubleshoot & is there anything gleeming that i
> > > am missing. Thanks|||Report server will only work against an SMTP server that accepts anonymous
or NTLM authentication. The best solution for email is to use a local SMTP
server as a relay to your smtp server. Set the pickup directory element in
the RSReportServer.config file to the local SMTP servers pickup directory
and the SendUsing element to 1. Then configure your local SMTP server to
relay the email to your actual SMTP server.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tzepesh" <Tzepesh@.discussions.microsoft.com> wrote in message
news:547E777A-F7A3-4F9A-A7AA-236F22E04966@.microsoft.com...
> It is notoriously difficult to get the subscriptions to work, I spent a
> week
> configuring a production server trying to do this and gave up, I have the
> feeling you need to re-install RS using different accounts/settings, which
> in
> my case wasn't an option. I ended up coding a small windows service that
> downloaded the report through a crafted URL and emailed it based on a
> schedule in a table. It actually took less to code that snippet than to
> configure the much glorified data driven subscription feature of RS.
> Microsoft shouldn't be in such a hurry to advertise features that won't
> even
> work in plain vanilla, no frills install out of the box.
> Regards,
> Tzepesh
> "Tango" wrote:
>> Can anyone help, please. Maybe a link to a ReportServer.config that is
>> successfully emailing reports might help.
>> Thankyou
>> "Tango" wrote:
>> > I have noted that the sql server agent has a job logged & shows
>> > suceeded when
>> > last run but I have recieved any emails. I have also noted a job in the
>> > process info that has a status of sleeping. Event log shows nothing
>> >
>> > "Tango" wrote:
>> >
>> > > I am having trouble getting a report emailed for the first time.
>> > > The timed subscription has been set. I have updated the
>> > > ReportServer.config
>> > > file to include the ip of the exchange server along with port number
>> > > although
>> > > im not sure where to enter a password. The IT guys are making sure
>> > > that the
>> > > exchange server will accept smtp requests from other servers. My
>> > > question is
>> > > what is the best method to troubleshoot & is there anything gleeming
>> > > that i
>> > > am missing. Thanks