Ad-Hoc Reporting for users in RS 2005 with Visual Studio 2005

My Supervisor and I attended a couple of Microsoft demos of SQL Reporting
Services 2005, and during those demos, the end user development environonment
was demoed. We are currently using SQL 2000 RS for a full set of Financial
reports for our 800+ users and would like to make available report writing to
our power users.
Are there any links that anybody knows of that explains setting up the
end-user VS2005 environment? Is there a place to start at in the SQL help
file that explains how users should be configured to use Visual Studio and
the Security implications?
Thanks in advance.RS comes with two ways to create reports. Report Builder and Report
Designer. The designer is essentially the same. Report Builder is a whole
new thing and is for power users. It does not use VS. I suggest reading up
on Report Builder. It is a smart client application (one click install).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alec Hardy" <AlecHardy@.discussions.microsoft.com> wrote in message
news:7C593508-C325-4B66-AE9F-84396A9AD123@.microsoft.com...
> My Supervisor and I attended a couple of Microsoft demos of SQL Reporting
> Services 2005, and during those demos, the end user development
> environonment
> was demoed. We are currently using SQL 2000 RS for a full set of
> Financial
> reports for our 800+ users and would like to make available report writing
> to
> our power users.
> Are there any links that anybody knows of that explains setting up the
> end-user VS2005 environment? Is there a place to start at in the SQL help
> file that explains how users should be configured to use Visual Studio and
> the Security implications?
> Thanks in advance.|||Do you know of any good websites for Report Builder/ad hoc reporting?
--
K. Thomas
"Bruce L-C [MVP]" wrote:
> RS comes with two ways to create reports. Report Builder and Report
> Designer. The designer is essentially the same. Report Builder is a whole
> new thing and is for power users. It does not use VS. I suggest reading up
> on Report Builder. It is a smart client application (one click install).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Alec Hardy" <AlecHardy@.discussions.microsoft.com> wrote in message
> news:7C593508-C325-4B66-AE9F-84396A9AD123@.microsoft.com...
> > My Supervisor and I attended a couple of Microsoft demos of SQL Reporting
> > Services 2005, and during those demos, the end user development
> > environonment
> > was demoed. We are currently using SQL 2000 RS for a full set of
> > Financial
> > reports for our 800+ users and would like to make available report writing
> > to
> > our power users.
> >
> > Are there any links that anybody knows of that explains setting up the
> > end-user VS2005 environment? Is there a place to start at in the SQL help
> > file that explains how users should be configured to use Visual Studio and
> > the Security implications?
> >
> > Thanks in advance.
>
>

Additional Problems with Reporting Services

I am trying to use Reporting Services but is proving more difficult than I envisaged. Here's the problem, when I try to use management studio to change the Server type to a Report server, it is disabled. Hence I cannot change it. When I read msdn, it stated that this was caused by the fact that report services was not installed. However, when I look at SQL Configuration Manager, it shows that Report Services is running. Am I not understanding something? What am I doing wrong?I know that in computing, that you should not do the same thing over and expect to get different results! I may have now have to disagree with that tenet. Somehow, magically, I am now able to set up reports in Business Intelligence, but I am still unable to change my Server type when Management Studio is started. May I get a response from one of these czars or do I have to put my fate/faith in magic?|||

Don't know if I'm a czar, but I have an answer. :)

This is by design, Management Studio Express does not support connections to Reporting Service. In fact, it only supports connections to Relational Databases. You would need to have the full version of Management Studio from one of the paid Editions of SQL Server to support connections to other services.

Mike

adding vb and visual C# to Visual Studio 2005 in reporting service

Hi,
Presently visual studio 2005 in SQL server 2005 reporting services has
business intelligence project templates.
I would like to know as to how to add Visual basic and Visual C# project
templates to Visual Studio 2005.
I am new to SQL Server 2005 reporting services.
I would highly appreciate this information.
Thanks for your help.
--
SamKYou have to install those projects. However, after doing this you might have
to re-install report designer. The reason is that SQL Server 2005 comes with
a version of visual studio that it installs if no VS is present. If VS is
present it integrates with it. I have found that if you install VS (for
instance installing VB.Net which installs a full version of Visual Studio)
that you need to re-install the report designer so it integrates with it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SamK" <SamK@.discussions.microsoft.com> wrote in message
news:07A0FD1E-9C4A-4FCD-BF5E-65CF12A62AE6@.microsoft.com...
> Hi,
> Presently visual studio 2005 in SQL server 2005 reporting services has
> business intelligence project templates.
> I would like to know as to how to add Visual basic and Visual C# project
> templates to Visual Studio 2005.
> I am new to SQL Server 2005 reporting services.
> I would highly appreciate this information.
> Thanks for your help.
> --
> SamK|||Bruce,
Thanks for your helpful suggestion. This is what I will do.
1) uninstall the Visual Studio 2005 that got installed along with SQL server
2005 reporting services
2) install the full version of Visual Studio 2005.
3) Reinstall the reporting services.
Is this correct?
Best Regards,
SamK
"Bruce L-C [MVP]" wrote:
> You have to install those projects. However, after doing this you might have
> to re-install report designer. The reason is that SQL Server 2005 comes with
> a version of visual studio that it installs if no VS is present. If VS is
> present it integrates with it. I have found that if you install VS (for
> instance installing VB.Net which installs a full version of Visual Studio)
> that you need to re-install the report designer so it integrates with it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "SamK" <SamK@.discussions.microsoft.com> wrote in message
> news:07A0FD1E-9C4A-4FCD-BF5E-65CF12A62AE6@.microsoft.com...
> > Hi,
> >
> > Presently visual studio 2005 in SQL server 2005 reporting services has
> > business intelligence project templates.
> > I would like to know as to how to add Visual basic and Visual C# project
> > templates to Visual Studio 2005.
> >
> > I am new to SQL Server 2005 reporting services.
> >
> > I would highly appreciate this information.
> > Thanks for your help.
> > --
> > SamK
>
>|||Yes. That will do what you want.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SamK" <SamK@.discussions.microsoft.com> wrote in message
news:9BEB930B-CE75-4281-9C0B-A171CCD4D035@.microsoft.com...
> Bruce,
> Thanks for your helpful suggestion. This is what I will do.
> 1) uninstall the Visual Studio 2005 that got installed along with SQL
> server
> 2005 reporting services
> 2) install the full version of Visual Studio 2005.
> 3) Reinstall the reporting services.
> Is this correct?
> Best Regards,
> SamK
>
> "Bruce L-C [MVP]" wrote:
>> You have to install those projects. However, after doing this you might
>> have
>> to re-install report designer. The reason is that SQL Server 2005 comes
>> with
>> a version of visual studio that it installs if no VS is present. If VS is
>> present it integrates with it. I have found that if you install VS (for
>> instance installing VB.Net which installs a full version of Visual
>> Studio)
>> that you need to re-install the report designer so it integrates with it.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "SamK" <SamK@.discussions.microsoft.com> wrote in message
>> news:07A0FD1E-9C4A-4FCD-BF5E-65CF12A62AE6@.microsoft.com...
>> > Hi,
>> >
>> > Presently visual studio 2005 in SQL server 2005 reporting services has
>> > business intelligence project templates.
>> > I would like to know as to how to add Visual basic and Visual C#
>> > project
>> > templates to Visual Studio 2005.
>> >
>> > I am new to SQL Server 2005 reporting services.
>> >
>> > I would highly appreciate this information.
>> > Thanks for your help.
>> > --
>> > SamK
>>|||Bruce,
After doing all this two more problems have come up.
1) For web service identity ASPNET is not assigned. the text box is
disabled and it is blank.
2) when I try to open the report manager (http://computername/reports the
application errors out with this message. I would request your help.
Server Error in '/Reports' Application.
----
Could not load file or assembly 'CppCodeProvider, Version=8.0.0.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies.
The module was expected to contain an assembly manifest.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.BadImageFormatException: Could not load file or
assembly 'CppCodeProvider, Version=8.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The module was
expected to contain an assembly manifest.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Assembly Load Trace: The following information can be helpful to determine
why the assembly 'CppCodeProvider, Version=8.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a' could not be loaded.
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value
[HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind
failure logging.
To turn this feature off, remove the registry value
[HKLM\Software\Microsoft\Fusion!EnableLog].
Stack Trace:
[BadImageFormatException: Could not load file or assembly 'CppCodeProvider,
Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of
its dependencies. The module was expected to contain an assembly manifest.]
System.RuntimeTypeHandle._GetTypeByName(String name, Boolean
throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark&
stackMark, Boolean loadTypeFromPartialName) +0
System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError,
Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) +72
System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError,
Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) +58
System.Type.GetType(String typeName) +48
System.CodeDom.Compiler.CompilerInfo.get_IsCodeDomProviderTypeValid() +9
System.Web.Compilation.CompilationUtil.GetRecompilationHash(CompilationSection ps) +1800
System.Web.Configuration.CompilationSection.get_RecompilationHash() +68
System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate2(StandardDiskBuildResultCache diskCache) +741
System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate(StandardDiskBuildResultCache diskCache) +46
System.Web.Compilation.BuildManager.RegularAppRuntimeModeInitialize() +419
System.Web.Compilation.BuildManager.Initialize() +235
System.Web.Compilation.BuildManager.InitializeBuildManager() +228
System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags)
+310
[HttpException (0x80004005): Could not load file or assembly
'CppCodeProvider, Version=8.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The module was
expected to contain an assembly manifest.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3435007
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +252
----
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET
Version:2.0.50727.210
--
SamK
"Bruce L-C [MVP]" wrote:
> Yes. That will do what you want.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "SamK" <SamK@.discussions.microsoft.com> wrote in message
> news:9BEB930B-CE75-4281-9C0B-A171CCD4D035@.microsoft.com...
> > Bruce,
> >
> > Thanks for your helpful suggestion. This is what I will do.
> > 1) uninstall the Visual Studio 2005 that got installed along with SQL
> > server
> > 2005 reporting services
> > 2) install the full version of Visual Studio 2005.
> > 3) Reinstall the reporting services.
> >
> > Is this correct?
> >
> > Best Regards,
> > SamK
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You have to install those projects. However, after doing this you might
> >> have
> >> to re-install report designer. The reason is that SQL Server 2005 comes
> >> with
> >> a version of visual studio that it installs if no VS is present. If VS is
> >> present it integrates with it. I have found that if you install VS (for
> >> instance installing VB.Net which installs a full version of Visual
> >> Studio)
> >> that you need to re-install the report designer so it integrates with it.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "SamK" <SamK@.discussions.microsoft.com> wrote in message
> >> news:07A0FD1E-9C4A-4FCD-BF5E-65CF12A62AE6@.microsoft.com...
> >> > Hi,
> >> >
> >> > Presently visual studio 2005 in SQL server 2005 reporting services has
> >> > business intelligence project templates.
> >> > I would like to know as to how to add Visual basic and Visual C#
> >> > project
> >> > templates to Visual Studio 2005.
> >> >
> >> > I am new to SQL Server 2005 reporting services.
> >> >
> >> > I would highly appreciate this information.
> >> > Thanks for your help.
> >> > --
> >> > SamK
> >>
> >>
> >>
>
>

Adding tables to SQL server database in visual studio?

Hi

I keep reading it's possible to add, amend ,etc. tables in visual studio but to do so I need access to the features that allow this.
I can connect to the database but I haven't been able to use any of these database features since they are "blanked" out.
Obviously, I can do all this at the server but ideally I would like to do it remotely.

Any suggestions?
Thanks in advance.In your server explorer, can you navigate to the tables?
-Servers
- <your server>
- SQL Servers
- <your SQL server>
- <your database>
- tables

From there you should be able to add, change, or delete tables.

-Ian|||Hi Ian

Thanks for the reply.

I can navigate to the tables but the menu features are not available for adding,etc. tables.
Could it be something at the server end that I need to change?

Thanks in advance.sql

Adding SSMSE 2005 as a Prerequisite to a Visual Studio Setup Project

Hi,

I'm am deploying an application that uses SQL Express and wish to also deploy SSMSE along with it.

I have the .msi but I don't know how to get the setup project to deploy this as it does SQLExpress and .Net Framework 2.0. (and I am using VS 2005 SE)

There is an MS article on creating "Custom Prerequisites" (http://msdn2.microsoft.com/en-us/library/ms165429(VS.80).aspx) which speaks to creating product and project manifests.

Has anyone does this for SSMSE? Or am I going about this in the wrong way?

Thanks in advance,

Keith

Hi Keith,

You're going about this the right way, if you want to use SSMSE as a pre-requisite you'll need to create a custom pre-requisite for this following the instructions on MSDN. (Microsoft has not created this package.) If you have questions about creating your own prerequisites for VS, I would suggest posting those questions to the ClickOnce forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=6&SiteID=1.

One thing to consider is that the licensing of SSMSE is such that it can only be deployed if you are also deploying SQL Express, independent deployment is not part of the license.

Mike

|||

Thanks Mike! I am deploying it with SQL Express as well.

Take care,

Keith

Adding SSMSE 2005 as a Prerequisite to a Visual Studio Setup Project

Hi,

I'm am deploying an application that uses SQL Express and wish to also deploy SSMSE along with it.

I have the .msi but I don't know how to get the setup project to deploy this as it does SQLExpress and .Net Framework 2.0. (and I am using VS 2005 SE)

There is an MS article on creating "Custom Prerequisites" (http://msdn2.microsoft.com/en-us/library/ms165429(VS.80).aspx) which speaks to creating product and project manifests.

Has anyone does this for SSMSE? Or am I going about this in the wrong way?

Thanks in advance,

Keith

Hi Keith,

You're going about this the right way, if you want to use SSMSE as a pre-requisite you'll need to create a custom pre-requisite for this following the instructions on MSDN. (Microsoft has not created this package.) If you have questions about creating your own prerequisites for VS, I would suggest posting those questions to the ClickOnce forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=6&SiteID=1.

One thing to consider is that the licensing of SSMSE is such that it can only be deployed if you are also deploying SQL Express, independent deployment is not part of the license.

Mike

|||

Thanks Mike! I am deploying it with SQL Express as well.

Take care,

Keith

Adding SSMSE 2005 as a Prerequisite to a Visual Studio Setup Project

Hi,

I'm am deploying an application that uses SQL Express and wish to also deploy SSMSE along with it.

I have the .msi but I don't know how to get the setup project to deploy this as it does SQLExpress and .Net Framework 2.0. (and I am using VS 2005 SE)

There is an MS article on creating "Custom Prerequisites" (http://msdn2.microsoft.com/en-us/library/ms165429(VS.80).aspx) which speaks to creating product and project manifests.

Has anyone does this for SSMSE? Or am I going about this in the wrong way?

Thanks in advance,

Keith

Hi Keith,

You're going about this the right way, if you want to use SSMSE as a pre-requisite you'll need to create a custom pre-requisite for this following the instructions on MSDN. (Microsoft has not created this package.) If you have questions about creating your own prerequisites for VS, I would suggest posting those questions to the ClickOnce forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=6&SiteID=1.

One thing to consider is that the licensing of SSMSE is such that it can only be deployed if you are also deploying SQL Express, independent deployment is not part of the license.

Mike

|||

Thanks Mike! I am deploying it with SQL Express as well.

Take care,

Keith

Adding procedure to SQL Server Express

I am adding (trying to add) a procedure (written by a friend of mine and someone who is experienced). I am adding it via the SQL Server Mgt. Studio Express. When I run it, it says that the command completed successfully, but it doesn't appear in the Procedure folder.

When I run my ASP 2.0 form that calls it, it says that it can't find the procedure.

Can anyone help me determine what to look for or what I might be doing wrong?

Thank you.

How exactly are you adding the object to the database inside the Management tools. Has you friend supplied a SQL script file and you are running it inside a new query window. If so you will need to make sure that the query you are running is inside the correct database. Generally you should have a use statement at the top of the database

Query for example

use northwind
go

and then have the Stored procedure script following it.

|||

He forgot the USE statement. Previously it was adding into the system area. My knowlede of procedures is limited, but I should have thought of that myself.

Thank you.

adding new queries to Server Management Studio

When ever I hit the CTRL+N to add a new query and then save it, why doesn't it get added to the current project I'm working on? Since it's not added, I have to open Windows Explorer, navigate to the right folder, then drag'n'drop it into the right project in my solution. A lot of work for something it should be doing by default.

What am I missing? Thanks.

This does not appear possible with SQL Server 2005 SP2. Could you file this on Microsoft Connect? http://connect.microsoft.com/SQLServer/Feedback/

Paul A. Mestemaker II

Program Manager

Microsoft SQL Server Manageability

http://blogs.msdn.com/sqlrem/

|||Done, id 275345.

adding new queries to Server Management Studio

When ever I hit the CTRL+N to add a new query and then save it, why doesn't it get added to the current project I'm working on? Since it's not added, I have to open Windows Explorer, navigate to the right folder, then drag'n'drop it into the right project in my solution. A lot of work for something it should be doing by default.

What am I missing? Thanks.

This does not appear possible with SQL Server 2005 SP2. Could you file this on Microsoft Connect? http://connect.microsoft.com/SQLServer/Feedback/

Paul A. Mestemaker II

Program Manager

Microsoft SQL Server Manageability

http://blogs.msdn.com/sqlrem/

|||Done, id 275345.

Adding logins via SSEUtil compared to SQL Server Management Studio

Hello all,

I am currently in the process of setting up an SQL Server Express installation that comes packaged with an application I have written. My problem is that I want to use SQL Server user management (not just windows users) which work fine if I set them up manually. I started writing a script that I have SSEUtil execute once the application is fully installed (a step in my installation script) which sets up the users and passwords etc. The script is similar to the following:

USE [DBName]
GO

EXEC sp_DropUser 'user1'
EXEC sp_DropUser 'user2'
EXEC sp_DropUser 'user3'
EXEC sp_DropUser 'user4'
GO

USE [master]
GO

EXEC sp_DropLogin 'user1'
EXEC sp_DropLogin 'user2'
EXEC sp_DropLogin 'user3'
EXEC sp_DropLogin 'user4'
GO

CREATE LOGIN user1 WITH Password = 'user1', CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
CREATE LOGIN user2 WITH Password = 'user2', CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
CREATE LOGIN user3 WITH Password = 'user3', CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
CREATE LOGIN user4 WITH Password = 'user4', CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO

USE [DBName]
GO

EXEC sp_AddUser 'user1'
EXEC sp_AddUser 'user2'
EXEC sp_AddUser 'user3'
EXEC sp_AddUser 'user4'
GO

ALTER USER user1 WITH DEFAULT_SCHEMA = MySchema
ALTER USER user2 WITH DEFAULT_SCHEMA = MySchema
ALTER USER user3 WITH DEFAULT_SCHEMA = MySchema
ALTER USER user4 WITH DEFAULT_SCHEMA = MySchema
GO

REVOKE ALTER,DELETE,INSERT,SELECT,UPDATE ON MySchema.Table1 FROM MyRole
REVOKE ALTER,DELETE,INSERT,SELECT,UPDATE ON MySchema.Table2 FROM MyRole
REVOKE ALTER,DELETE,INSERT,SELECT,UPDATE ON MySchema.Table3 FROM MyRole
REVOKE ALTER,DELETE,INSERT,SELECT,UPDATE ON MySchema.Table4 FROM MyRole
GO

EXEC sp_DropRole 'MyRole'
EXEC sp_AddRole 'MyRole'
GO

GRANT ALTER,DELETE,INSERT,SELECT,UPDATE ON MySchema.Table1 TO MyRole
GRANT ALTER,DELETE,INSERT,SELECT,UPDATE ON MySchema.Table2 TO MyRole
GRANT ALTER,DELETE,INSERT,SELECT,UPDATE ON MySchema.Table3 TO MyRole
GRANT ALTER,DELETE,INSERT,SELECT,UPDATE ON MySchema.Table4 TO MyRole
GO

EXEC sp_AddRoleMember 'MyRole','user1'
EXEC sp_AddRoleMember 'MyRole','user2'
EXEC sp_AddRoleMember 'MyRole','user3'
EXEC sp_AddRoleMember 'MyRole','user4'
GO

Now if I run this script from within SQL Server Management Studio it executes perfectly. The logins add, the role is added, each user is added to the database logins and assigned to the role, the schema is set correctly on each user.

Then when I try to run the exact same script from the SSEUtil application (SSEUTIL -s PCNAME\Instance -run USERS.SQL), it processes everything, except the Logins.

This is frustrating as it means to install for a client I would need to either get them to open the management console and run the script from there, or I have to go to site just to setup users.

Am I on the right track? Or is there another way to automate the adding of Logins?

Thanks in advance,

DSXC

Just an update.

I did a check within my database and found that the sys.syslogins has the users (when I do a select from the view) but they just don't work. The only difference I can see between my scripted login I created and the SA user is the flag for sysadmin, but thats understandable as these users are not to be sysadmins.

Is there another table that actually enables the login?

DSXC

|||

I noticed a lot of people using the SQLCMD.EXE instead of the SSEUtil.EXE I was using so I thought I'd give it a try.

Lo and behold... it works!

Talk about crazy... oh well. Just so everyone knows, use the SQLCMD.EXE over SSEUtil.exe... gah!

EDIT: I didn't mention the command line to run it...

SQLCMD.EXE -i MYSCRIPT.SQL

Hope that helps.

DSXC

|||

Hi DSXC,

Sorry to have missed this thread earlier, I can shed some light on what you're seeing.

SSEUtil.exe is an unsupported tool primarily used for troubleshooting User Instance problems, it is not meant to be used as a general solution for runing scripts, nor is it licensed to be deployed with your application. Additionally, the default mechanism of SSEUtil works against the User Instance, not the parent instance, so my guess is it was not working the way you think it was.

SQLCmd is the general scripting utility that is installed with all copies of SQL 2005 and is exactly the tool you should be using for what you wish to accomplish, but you've already discovered that.

Mike

|||

Hi Mike,

Thanks for your response. It makes a bit more sense now.

I found the SSEUtil app with a search on attaching the database to my SQL Server so I guessed it would have worked running scripts against it also. I just noticed that the SSEUtil doesn't attach my database correctly either so I've now transferred over to using another SQL script.

Again thanks for your response.

DSXC

Adding Integration Services Node in Server Management Studio

Hi,
Am just getting started with SSIS. Based on an article I saw online, I would expect to find an "Integration Services" node in Server Management Studio, but I don't see this node. I'm trying to create and execute a simple package.
Running...
Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)
Apr 9 2005 20:56:37
Copyright (c) 1988-2004 Microsoft Corporation
Beta Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
...on a named instance.
Thanks,
krog
Have you tried in Object Explorer

Connect | Integration Services

Allan|||There it is. Thank you!|||I am testing this on Windows XP and when I run SSIS, I can connect to server but I don't see a way to connect to Integration Services. I see in the Providers folder DTSPackage but how do I execute this assuming this is what I need. I am new to SQL Express and I am trying to import a DBF file and create a database.

Neil|||I am trying to connnect through Object Browser, but I am getting Access Denied error. Please note I am not the Admin on the box. What kind of permission I need to register Integration Services connection on my Management studio? Finally I want to import some packages I developed on msdb.

Thanks|||Hi,

I am also experiencing Access Denied errors when using object explorer (on my workstation) to connect to SSIS.

I have searched and tried some tips but I am still not able to connect. I am a local administrator on the sql server, i have added myself to db_dtsadmin role in the msdb database.

Can anyone please shed some light on how to connect remotely to SSIS.

Thanks,
Jason|||SSIS only comes with Standard edition and above. SQL Express does not include SSIS.|||

Any additional information about this?

I also recieve "Access denied" when attempting to add an Integration Service connection through the object browser. It works fine on a co-worker's workstation. I have disabled my firewall. I'm on the same subnet as my co-worker who is able to connect.

Best regards,

Shad

Adding Integration Services Node in Server Management Studio

Hi,
Am just getting started with SSIS. Based on an article I saw online, I would expect to find an "Integration Services" node in Server Management Studio, but I don't see this node. I'm trying to create and execute a simple package.
Running...
Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)
Apr 9 2005 20:56:37
Copyright (c) 1988-2004 Microsoft Corporation
Beta Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
...on a named instance.
Thanks,
krog
Have you tried in Object Explorer

Connect | Integration Services

Allan
|||There it is. Thank you!
|||I am testing this on Windows XP and when I run SSIS, I can connect to server but I don't see a way to connect to Integration Services. I see in the Providers folder DTSPackage but how do I execute this assuming this is what I need. I am new to SQL Express and I am trying to import a DBF file and create a database.

Neil|||I am trying to connnect through Object Browser, but I am getting Access Denied error. Please note I am not the Admin on the box. What kind of permission I need to register Integration Services connection on my Management studio? Finally I want to import some packages I developed on msdb.

Thanks|||Hi,

I am also experiencing Access Denied errors when using object explorer (on my workstation) to connect to SSIS.

I have searched and tried some tips but I am still not able to connect. I am a local administrator on the sql server, i have added myself to db_dtsadmin role in the msdb database.

Can anyone please shed some light on how to connect remotely to SSIS.

Thanks,
Jason|||SSIS only comes with Standard edition and above. SQL Express does not include SSIS.|||

Any additional information about this?

I also recieve "Access denied" when attempting to add an Integration Service connection through the object browser. It works fine on a co-worker's workstation. I have disabled my firewall. I'm on the same subnet as my co-worker who is able to connect.

Best regards,

Shad

Adding Integration Services Node in Server Management Studio

Hi,
Am just getting started with SSIS. Based on an article I saw online, I would expect to find an "Integration Services" node in Server Management Studio, but I don't see this node. I'm trying to create and execute a simple package.
Running...
Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)
Apr 9 2005 20:56:37
Copyright (c) 1988-2004 Microsoft Corporation
Beta Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
...on a named instance.
Thanks,
krog
Have you tried in Object Explorer

Connect | Integration Services

Allan|||There it is. Thank you!|||I am testing this on Windows XP and when I run SSIS, I can connect to server but I don't see a way to connect to Integration Services. I see in the Providers folder DTSPackage but how do I execute this assuming this is what I need. I am new to SQL Express and I am trying to import a DBF file and create a database.

Neil|||I am trying to connnect through Object Browser, but I am getting Access Denied error. Please note I am not the Admin on the box. What kind of permission I need to register Integration Services connection on my Management studio? Finally I want to import some packages I developed on msdb.

Thanks|||Hi,

I am also experiencing Access Denied errors when using object explorer (on my workstation) to connect to SSIS.

I have searched and tried some tips but I am still not able to connect. I am a local administrator on the sql server, i have added myself to db_dtsadmin role in the msdb database.

Can anyone please shed some light on how to connect remotely to SSIS.

Thanks,
Jason|||SSIS only comes with Standard edition and above. SQL Express does not include SSIS.|||

Any additional information about this?

I also recieve "Access denied" when attempting to add an Integration Service connection through the object browser. It works fine on a co-worker's workstation. I have disabled my firewall. I'm on the same subnet as my co-worker who is able to connect.

Best regards,

Shad

Adding Integration Services Node in Server Management Studio

Hi,
Am just getting started with SSIS. Based on an article I saw online, I would expect to find an "Integration Services" node in Server Management Studio, but I don't see this node. I'm trying to create and execute a simple package.
Running...
Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)
Apr 9 2005 20:56:37
Copyright (c) 1988-2004 Microsoft Corporation
Beta Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
...on a named instance.
Thanks,
krog
Have you tried in Object Explorer

Connect | Integration Services

Allan|||There it is. Thank you!|||I am testing this on Windows XP and when I run SSIS, I can connect to server but I don't see a way to connect to Integration Services. I see in the Providers folder DTSPackage but how do I execute this assuming this is what I need. I am new to SQL Express and I am trying to import a DBF file and create a database.

Neil|||I am trying to connnect through Object Browser, but I am getting Access Denied error. Please note I am not the Admin on the box. What kind of permission I need to register Integration Services connection on my Management studio? Finally I want to import some packages I developed on msdb.

Thanks|||Hi,

I am also experiencing Access Denied errors when using object explorer (on my workstation) to connect to SSIS.

I have searched and tried some tips but I am still not able to connect. I am a local administrator on the sql server, i have added myself to db_dtsadmin role in the msdb database.

Can anyone please shed some light on how to connect remotely to SSIS.

Thanks,
Jason|||SSIS only comes with Standard edition and above. SQL Express does not include SSIS.|||

Any additional information about this?

I also recieve "Access denied" when attempting to add an Integration Service connection through the object browser. It works fine on a co-worker's workstation. I have disabled my firewall. I'm on the same subnet as my co-worker who is able to connect.

Best regards,

Shad

Adding images with SQL Server Express Management Studio

Can I add images to a table with SQL Server Express Management Studio? If so, how, if not, what alternative methods other than the point-and-click can I use?

Thanks in advance,

Fedor Steeman

hi Fedor,

there's no "point and click" solution for your requirement in SSMS... but you can "load" a column executing the appropriate Transact-SQL statement..

something like

SET NOCOUNT ON;

USE tempdb;

GO

CREATE TABLE dbo.TestTB (

Id int NOT NULL PRIMARY KEY,

img varbinary(MAX) NULL

);

GO

PRINT 'retrieve the img from file';

DECLARE @.img varbinary(MAX);

SET @.img = (

SELECT Q.BulkColumn

FROM OPENROWSET(BULK 'D:\MVPLogo.gif', SINGLE_BLOB) AS Q

);

SELECT CONVERT(varchar(MAX),@.img);

PRINT 'then you can insert it into the desired table';

INSERT INTO dbo.TestTB VALUES ( 1 , @.img );

SELECT * FROM dbo.TestTB;

GO

DROP TABLE dbo.TestTB;

--<

retrieve the img from file

--

GIF89as ′ ? 4:u???jt￡CJ?K{abridged}

then you can insert it into the desired table

Id img

--

1 GIF89as ′ ? 4:u???jt￡CJ?K{abridged}

and that's it..

regards

Adding BI Templates to Visual Studio 2005 - 2008

After installing SQL Server (both 2005 and 2008) sometimes the BI Templates are missing from the new project dialog. Is there a way to find those templates and add them after a SQL Server install? I have searched the web and Microsoft MSDN, but found no information. Thank you if you can help me.

Hi,

From your description, do you mean the Business Intelligence project template disappear in the create project dialogue?

Based on my understanding, you can try to open "SQL Server Business Intelligence Development Studio" from SQLServer 2005 menu group instead of starting Visual Studio designer. If you still can't find the business intelligence project template. Please make sure that if you have choose the "SQLServer Reporting Service" to be installed while you installing the SQLServer2005.

Thanks.

|||

No, the problem is that they do not appear in VS/BIDS even if SSRS is installed. The templates must be available on the web somewhere and the correct folder location and configuration to add them to the VS/BIDS interface must exist somewhere.

Adding a user to a database in SQL Server Management Studio Express?

Can someone provide me with instructions or a link on how to add a user to a database using SQL Server Management studio Express?

I also would like to know how you set the db_owner permission to the user?

My host has an sql express database and I would like to use the same connection string on my local machine, but need to set up the username/pw on the database locally.

Thanks

go to the security tab of the management express

in the object explorer. double click logins to expand

right click and then add new user

from there you can grant the user access to database.

you can also open the database to add new user to it when you

already created a login in the security tab