Deploy On The Hoster

Oct 6, 2006

Dears,
I have devoloped an application ASP.NET 2.0.
Before I have builded the aspnetdb throught the command then I built some tables and stored procedures on this db. (My db is sql express 2005 and my hoster db is sql 2005 workgroup)
My hoster doesn't allow connection Management studio express, doesn't allow attach or restore functionalities.
Than I have built my script db (contains Tables, Views and Stored Procedures), I have substituted the dbo with my user account in the script because my hoster doesn't allow the dbo access.
I have also transfered my site files (.aspx, img, etc.) on the server.
When I try to access the db I receive this error (for example when I push on the button create user):
The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.

Please could you help me?

Thank you.

View 1 Replies

Transfering SQL2005 DB To Hoster

Mar 23, 2007

Hi,
I've a problem that I haven't experienced before and need some help. I've developed an app that works fine locally and have uploaded via FTP to my host provider - .NET 2 and SQL2005 Express.
I'm now getting problems accessing the site. In the application load event I load a couple of application state items from the database. When it hits the default aspx page, it throws an Object reference not set to an instance of an object. error because the application state items haven't been loaded. The host then tried to load the database using SQL Management Express to ensure there wasn't a problem with the database and this is where I get confused.....
When they try to attach it, the message column n the "Attach Databases" screen says the file cannot be found. In the "Current File Path" column, it points to the path of my local machine, i.e. H:SourceClubApp_Dataclub.mdf. This leads me to believe that somewhere in the database the original file path is noted and used. I can't find this and wondered if anyone has come accross this issue before?? The log file has been deleted.
Any help and advice appreciated.
Terry.

View 6 Replies View Related

Web Hoster Only Allows 1 Sql Server Database

Jul 23, 2005

What can be done if the shared web hoster I am using allows only 1 sqlserver database and a second web application I would like to install isconfigured to use its own database?can databases be nested, one within another?thanks,-Steve

View 4 Replies View Related

Create Database At Shared Hoster Site

Jul 23, 2005

I have an sql script that I ran on my local system using osql. Itcreated all the tables, views, and even inserted sample data into thetables.Now I need to create that same database on a shared hoster site. Onlythe hoster does not allow the running of osql.How can I create my sql server database on my shared hoster site?Can I save and restore my database somehow?Is there a stored procedure I can run which will run the .sql scriptfile?thanks,-Steve

View 4 Replies View Related

SQL Server 2005 Replication To Internet Provider (Hoster)

Feb 27, 2007

I have a question and bear with me because I am pretty new to this topic.

I have a SQL SERVER 2005 with a Client Server Application. Now I want to add a Webinterface. Sinice there is no infrastructure for hosting our own server. I want to go to an external hoster/provider.

Now my question is it possiple to replicate a snap-shot of the database to an web hoster?

If yes, what does my hosting package requieres beside SQL SERVER and ASP.NET. Any Services and open ports? What about Security?

When I replicate via push Service from my local SQL SERVER do I have to have a tunnel to the provider? Or external network access to my network via VPN. Or is there a way of doing it via HTTP? HTTPS? (I think I saw some settings about FTP replication...). Because of the Infrastructure Problems mentioned above...

It would be great if someone could give me closer information about this topic...

Links, Ressources, Tipps, Tricks, Tools... just anything... would be appriciated very much...

Thx.

View 3 Replies View Related

Unable To Deploy Package Using Deploy Wiz Or Mgmt Studio

Jun 18, 2007

Am getting errors trying to deploy a dtsx created by ms (the reporting services execution log one) to which I have made zero changes, but it is not working (2 errors shown below)

error from deployment wizard:
===================================

Could not save the package "H:SSISRSlogRSExecutionLog_UpdateinDeploymentRSExecutionLog_Update.dtsx" to SQL Server "xxxxxxxxxxx". (Package Installation Wizard)

===================================

The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.

------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)
at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.SavePackageToSqlServer(WizardInputs wizardInputs, String packagePassword, Boolean bUseSeverEncryption, String serverName, String userName, String password, String packageFilePath, List`1 configFileNames)
at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.InstallPackagesToSqlServer(WizardInputs wizardInputs)

===================================

The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.

------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToSQLServer(IDTSPackage90 Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName, String ServerPassword)
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)

error from sql management studio
===================================

Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)

------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)

View 7 Replies View Related

Local SQL 2005 Express To Hoster SQL 2005 Server

Aug 24, 2007

I have been creating applications using SQL Express and uploading them to my hoster. No problems there. Now, I feel I'm ready to the next step and would like to start using my hoster SQL Server. I have created a database in their server, now how do I move my created SQL Express Database to their regular SQL Server? Is there a way to run a tool against my local DB and create a script to run in my hoster? What is the best practise here?
Your help is appreciated.

View 4 Replies View Related

How To Deploy The Database

Nov 9, 2007

Hi All,
Can anyone tell me,is it possible to create an exe or msi for sql stored procedures,tables and triggers?I want to deploy the database objects(stored proc,tables,views and functions) as an exe file..just like publishing and deploying the asp.net application.Is it possible for sql server database objects.Pls,let me know.

Thank U

View 4 Replies View Related

Which Database To Deploy

Nov 17, 2005

I'm deploying an ASP .Net application on which 20 users will be working at the same time. The database will start at less than 100mb. Is SQL EXPRESS 2005 powerfull enough to use for such an application. Thanks in advance for your answers

View 1 Replies View Related

Can't Deploy. No TargetServerURL

Jun 8, 2008

I have a report that I am trying to deploy. I right-clicked my report in the solutions explorer, then select "deploy" but then I get the following error:

Microsoft Report Designer
The project cannot be deployed because no target server is specified. Provide a value for the TargetServerURL property in the property page for this project.

So then I go to the properties page but there isn't a TargetServerURL field! There is only a file name and full path field. Does anyone know what is wrong? Could it be that I need IIS installed on my machine?

More info:
Software installed from http://www.microsoft.com/express/sql/download/default.aspx:
-Microsoft SQL Server 2005 Express Edition
-SQL Server Management Studio Express
-Install Microsoft SQL Server 2005 Express Edition with Advanced Services
-Microsoft SQL Server 2005 Express Edition Toolkit

Windows XP Home Edition

View 6 Replies View Related

Better Way To Deploy SSIS Pkg

Nov 2, 2007

Hi, all,

I am looking for a way to deploy SSIS pkg from dev to test/prod.

Both BOL and MSDN/TecNet samples are complicated. Do I miss the old good days of DTS!

Thanks!

View 1 Replies View Related

Deploy .MDF To A Web Host

Mar 17, 2006

Hi all,I'm new to SQLServer (Express edition) so I was wondering: if the webhost supports SQLServer 2005 do I just need to move the .MDF file to mydirectory on the web host to be able to use it?Thanks,Lorenzo

View 3 Replies View Related

How Should I Deploy The Database

Apr 17, 2008

Hi all,
I have created a database in MS-Access. I want to deploy that database on the local server, how can i do it?

Let me clear, i have created a DSN for my database. I want to deploy a report on RServer(on SQL Server2005). This DSN will be the datasource for the report. When i am trying to deploy this report with this DSN i am getting an error message
"Cannot create a connection to data source 'DataSource2'. (rsErrorOpeningConnection)". Could any one help me?

Thanks,

View 1 Replies View Related

Cannot Deploy My Report

Jul 31, 2007

Hi, there;

I created a report using Report Sevice, but I cannot deploy it because of the security issue. If I try to open IIS, I got "Access Denied" message.

I checked another two developers' user settings, they are in the same user group as I am, but they can create/deploy report service.

So what should I need to create/deploy my report service?

cheers.

View 2 Replies View Related

Can Not Deploy Reports

Feb 27, 2008

I have created a report project file on my local machine.Now I'm trying to deploy those reports to a development server. I have installed sql server and tools in my local machine but never configured reporting services. When I try to deploy those reports, it asks username and password for reporting services login.
But usually as far as I know, i should be able to deploy my reports without entering password etc. Even if I enter username and password, still they dont work.
Is that becase I install SQL server in my local machine?
Does anyone know why?

Thanks

View 11 Replies View Related

Can Not Deploy To Localhost

Apr 29, 2008

I am trying to deploy a project to localhost, but I get the following error. I have only one package in this project.

"Could not save the package "C:......lah.dtsx" to SQL Server "localhost".

I tried deploying other projects that I've successfully deployed before and those also fail with the same message. Am I missing something really basic here?

View 7 Replies View Related

How To Deploy Reports.

Jul 10, 2007

Hi,

I have a web project and created a setup project for it. And I have to create reports using sql server reporting services. For this I have created an reportserver project and created two reports.

I have to create a setup file to install these reports in a remote machine.

How to do this?

where this .rdl and .rds files will be stored in the reportserver.

Regards,

Murali

View 4 Replies View Related

Getting Is Not Static When Trying To Deploy

Nov 10, 2006

I'm attemping to deploy a crypto class that we use on a desktop app to SQL Server. I'll use the encryptstring/decryptstring found in this class as User Defined Functions on SQL Server. When I try to deploy the class I'm getting this error:

Error 1 Method, property or field 'EncryptString' of class 'EncryptingDecryptingOASISPWDS.Crypto' in assembly 'EncryptingDecryptingOASISPWDS' is not static. EncryptingDecryptingOASISPWDS

Here is the code:

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

Imports System.Security.Cryptography

Imports System.Text 'for UnicodeEncoding

Imports System.IO 'for MemoryStream, FileStream, Stream, Path

Imports System.Threading 'for Thread.Sleep

Partial Public Class Crypto

'Private Const CodeVersion As String = "01.00.00"

'class member variables

Private m_sPassPhrase As String

'class private variables

Private mbytKey() As Byte 'crypto key

Private mbytIV() As Byte 'Initialization Vector

Private mbKeyIsSet As Boolean = False

Private mksKeyNotSetException As String = "Crypto passphrase is not set."

Private mksPassphraseTooSmall As String = "PassPhrase length must be at least {0} characters."

'--- class constructors

Public Sub New()

'no passphrase is useful for GetHashString/ValidPassword methods

End Sub

Public Sub New(ByVal CryptoPassPhrase As String)

PassPhrase = CryptoPassPhrase

End Sub

'--- class public properties

'generate and store encryption key & iv from passphrase

Public Property PassPhrase() As String

Get

Return m_sPassPhrase

End Get

Set(ByVal Value As String)

Const iMinLength As Integer = -1 '-1 disables min length

m_sPassPhrase = Value.Trim

'enforce a rule on minimum length if desired here

If (Value.Length > iMinLength) Or (iMinLength = -1) Then

Dim sha2 As New SHA256Managed()

'256 bits = 32 byte key

mbytKey = sha2.ComputeHash(BytesFromString(m_sPassPhrase))

'convert to Base64 for Initialization Vector, take last 16 chars

Dim sKey As String = Convert.ToBase64String(mbytKey)

mbytIV = Encoding.ASCII.GetBytes(sKey.Remove(0, sKey.Length - 16))

mbKeyIsSet = True

sha2 = Nothing

Else

mbKeyIsSet = False

Throw New Exception(String.Format(mksPassphraseTooSmall, (iMinLength + 1).ToString))

End If

End Set

End Property

'decrypt a stream

Public Function DecryptStream(ByVal EncryptedStream As MemoryStream) As MemoryStream

If mbKeyIsSet Then

Try

'create Crypto Service Provider, set key, transform and crypto stream

Dim oCSP As New RijndaelManaged()

oCSP.Key = mbytKey

oCSP.IV = mbytIV

Dim ct As ICryptoTransform = oCSP.CreateDecryptor()

Dim cs As CryptoStream = New CryptoStream(EncryptedStream, ct, CryptoStreamMode.Read)

'get bytes from encrypted stream

Dim byteArray(EncryptedStream.Length - 1) As Byte

Dim iBytesIn As Integer = cs.Read(byteArray, 0, EncryptedStream.Length)

cs.Close()

'create and write the decrypted output stream

Dim plainStream As New MemoryStream()

plainStream.Write(byteArray, 0, iBytesIn)

Return plainStream

Catch ex As Exception

Return Stream.Null

End Try

Else

Throw New Exception(mksKeyNotSetException)

End If

End Function

'decrypt a string - wrapper without Base64 flag (True by default)

Public Function DecryptString(ByVal EncryptedString As String) As String

Return _DecryptString(EncryptedString, True)

End Function

'decrypt a string - wrapper with Base64 flag

Public Function DecryptString(ByVal EncryptedString As String, ByVal Base64 As Boolean) As String

Return _DecryptString(EncryptedString, Base64)

End Function

'encrypt a stream

Public Function EncryptStream(ByVal PlainStream As MemoryStream) As MemoryStream

Try

'open stream for encrypted data

Dim encStream As New MemoryStream()

'create Crypto Service Provider, set key, transform and crypto stream

Dim oCSP As New RijndaelManaged()

oCSP.Key = mbytKey

oCSP.IV = mbytIV

Dim ct As ICryptoTransform = oCSP.CreateEncryptor()

Dim cs As CryptoStream = New CryptoStream(encStream, ct, CryptoStreamMode.Write)

'get input stream into byte array

Dim byteArray() As Byte = PlainStream.ToArray()

'write input bytes to crypto stream and close up

cs.Write(byteArray, 0, PlainStream.Length)

cs.FlushFinalBlock()

cs.Close()

Return encStream

Catch ex As Exception

Return Stream.Null

End Try

End Function

'encrypt a string - wrapper without Base64 flag (True by default)

<Microsoft.SqlServer.Server.SqlFunction()> _

Function EncryptString(ByVal PlainText As String) As String

Return _EncryptString(PlainText, True)

End Function

''encrypt a string - wrapper with Base64 flag

<Microsoft.SqlServer.Server.SqlFunction()> _

Public Function EncryptString2(ByVal PlainText As String, ByVal Base64 As Boolean) As String

Return _EncryptString(PlainText, Base64)

End Function

'calculates the hash of InputValue, returns a string

'- SHA1 hash is always 20 bytes (160 bits)

Public Function GetHashString(ByVal InputValue As String) As String

Try

Dim inputBytes() As Byte = BytesFromString(InputValue)

Dim hashValue() As Byte = New SHA1Managed().ComputeHash(inputBytes)

Return BytesToHexString(hashValue)

Catch ex As Exception

Return String.Empty

End Try

End Function

'returns True if hash of Passphrase matches HashValue

Public Function ValidPassword(ByVal Passphrase As String, ByVal HashValue As String) As Boolean

Return (GetHashString(Passphrase) = HashValue)

End Function

'internal string decryption

Private Function _DecryptString(ByVal EncryptedString As String, ByVal Base64 As Boolean) As String

Try

'put string in byte array depending on Base64 flag

Dim byteArray() As Byte

If Base64 Then

byteArray = Convert.FromBase64String(EncryptedString)

Else

byteArray = BytesFromString(EncryptedString)

End If

'create the streams, decrypt and return a string

Dim msEnc As New MemoryStream(byteArray)

Dim msPlain As MemoryStream = DecryptStream(msEnc)

Return BytesToString(msPlain.GetBuffer)

Catch ex As Exception

Return String.Empty

End Try

End Function

'internal string encryption

Private Function _EncryptString(ByVal PlainText As String, ByVal Base64 As Boolean) As String

Try

'put string in byte array

Dim byteArray() As Byte = BytesFromString(PlainText)

'create streams and encrypt

Dim msPlain As New MemoryStream(byteArray)

Dim msEnc As MemoryStream = EncryptStream(msPlain)

'return string depending on Base64 flag

If Base64 Then

Return Convert.ToBase64String(msEnc.ToArray)

Else

Return BytesToString(msEnc.ToArray)

End If

Catch ex As Exception

Return String.Empty

End Try

End Function

'returns a Unicode byte array from a string

Private Function BytesFromString(ByVal StringValue As String) As Byte()

Return (New UnicodeEncoding()).GetBytes(StringValue)

End Function

'returns a hex string from a byte array

Private Function BytesToHexString(ByVal byteArray() As Byte) As String

Dim sb As New StringBuilder(40)

Dim bValue As Byte

For Each bValue In byteArray

sb.AppendFormat(bValue.ToString("x2").ToUpper)

Next

Return sb.ToString

End Function

'returns a Unicode string from a byte array

Private Function BytesToString(ByVal byteArray() As Byte) As String

Return (New UnicodeEncoding()).GetString(byteArray)

End Function

'Return True when the file is available for writing

'- returns False if output file locked, for example

Private Function CheckWriteAccess(ByVal FileName As String) As Boolean

'2 second delay with 10,200

Dim iCount As Integer = 0 'retry count

Const iLimit As Integer = 10 'retries

Const iDelay As Integer = 200 'msec

While (iCount < iLimit)

Try

Dim fs As FileStream

fs = New FileStream(FileName, FileMode.Append, _

FileAccess.Write, FileShare.None)

fs.Close()

Return True

Catch ex As Exception

Thread.Sleep(iDelay)

Finally

iCount += 1

End Try

End While

Return False

End Function

End Class

View 4 Replies View Related

How To Deploy An Assembly (CLR)?

Nov 2, 2006

Good day to ALL,

I have already setup a db to my client.

My sp's are all created using CLR.

If my sp's are changed, how do I deploy them back to my client?

I usually send them a backup of the DB during the first few implementation.

But currently, their DB now contains live data, so I can't just let them restore the backup.

Is there another way?

Thanks and more power!

Arthur

View 1 Replies View Related

SQL CE Develop/Deploy

Jul 26, 2007

Hello all,
I've looked through this forum and haven't found an answer to my question, but I'll make this short and sweet, as I know your time is valuable.
I've taken a MS Access database and turned it into an SQL database for our server, it works. However, I want to make an identical database (to distribute to 30-40 employees) in SQL CE, so that employees can work on their laptops offline and sync their data to the main database when they return to the office. Am I going in the right direction, or is there a better way to do this?
I won't bother you for a step-by-step, but any and all info/guidance you could provide would be of great use to me.
Thanks for your time!!!

CG

View 3 Replies View Related

How To Deploy DSN On Server

Apr 18, 2008

Hi all,
Ther is a DSN (fileDSN, SystemDSN, UerDSN) on the client machine. User of the client machine has created a DSN which is connecting to the MS-Access database of his own machine. When user deploy that DSN to the Local Server, Server getting problem to finding the DSN (which is made on client).
Please help me how to Deploy this DSN to server.

Thanks,

View 1 Replies View Related

How Best To Deploy Database?

Jul 19, 2006

What would be the best way to deploy a database to customers?

Execute sql scripts to create the database on the customer's server, or distribute an .mdf file?

Package as msi?

Other ideas?

View 3 Replies View Related

Deploy To Another Server

Apr 13, 2006

I do not have access to VS, but I hear it can do this... how can I do it without VS?

I am using CREATE ASSEMBLY to load dll form my server to SQLServer on my server (Same machine). How can I load the dll to another server? Do I have to write it on a directory on that server first? I tried to run the command from my pc connected to the other server, and I get a "cannot find file" error.

View 6 Replies View Related

Deploy With Clickonce

Dec 23, 2007

Question about deploying a SQL compact database with Clickonce. Deploying the first time is straightforward and that works OK but I am not so sure about consequent releases, how do I deal with the that?
If I mark the file as dont deploy that will, of course, work fine for those that have installed the first release but not for thoses that havent.
What about if I make a change to the database, adding a table for example. How do I go about that? I obviously dont want to loose any of the existing data?

Thx and Happy Christmas to all

View 1 Replies View Related

Using Sql To Deploy A Database

Feb 1, 2007

I am trying to write an installation for my application.

I am using an SQL Express database as well as an ODBC driver to connect and querry an existing interbase database.

Therefore the install needs to do the following:

Install .NET - done

Install SQL Express - done

Install application - done

copy some XML files - done

Install ODBC Driver - done

Create database - not done

I am using a setup and deployment project to do the above. I have also written a small application to install the ODBC Driver and attepmt to create the database which I intend to run as a custom action if possible.

I have used the SQL management studio script wizard to write an sql script for creating the database with the intention of using an SQLconnection to run the script into the database but I can't seem to be able to make the connection.

I am trying using the following connection string...

Data Source=.SQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatamaster.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True

But I get the following error message...

System.Data.SqlClient.SqlException: Unable to open the physical file
"C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatamaster.mdf".
Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".

An attempt to attach an auto-named database for file C:Program FilesMicrosoft
SQL ServerMSSQL.1MSSQLDatamaster.mdf failed. A database with the same name
exists, or specified file cannot be opened, or it is located on UNC share.

Any ideas on how to do this?

Cheers in advance.

kevin

View 12 Replies View Related

How To Deploy .mdf Files

Jun 13, 2006

Hi Guys,

I have a problam. I wanna deploy my application that it has data.mdf file.

When I install and test it I get this message:

---------------------------
Microsoft SQL Server Login
---------------------------
Connection failed:
SQLState: '42000'
SQL Server Error: 5133
[Microsoft][SQL Native Client][SQL Server]Directory lookup for the file "C:Program FilesMyDicDatabaseData.mdf" failed with the operating system error 5(Access is denied.).
Connection failed:
SQLState: '42000'
SQL Server Error: 1832
[Microsoft][SQL Native Client][SQL Server]Could not attach file 'C:Program FilesMyDicDatabaseData.mdf' as database 'MyDic'.

---------------------------
OK
---------------------------

I have to mention that:

SQL Server: SQL Server 2005 Express

Operating System: Windows XP SP2

and I'm Local Admin.

Some parts of my code are:

lstrcpy(szDataDir,

TEXT("DRIVER={SQL Native Client};SERVER=.\sqlexpress;Trusted_Connection=Yes;DATABASE=MyDic;AttachDBFileName="));

GetCurrentDirectory(sizeof(szCurrentDir), szCurrentDir);

lstrcat(szCurrentDir, TEXT("\Database\Data.mdf;"));

lstrcat(szDataDir, szCurrentDir);

SQLDriverConnect(hdbc, hWnd, szDataDir, SQL_NTS, szConnStrOut, sizeof(szConnStrOut), &cbConnStrOut, SQL_DRIVER_COMPLETE);

How can I fix it?

Regards

View 18 Replies View Related

How To Deploy A Package?

Jan 31, 2007

Hallo

I created my first Package and i am not able to deploy it in my SQL server.

I created a Development Utility and in the OutputPath i got a *.dtsx and a *.SSISDevelopmentManifest file.
When i run the packaage (*.dtsx) it works but when i try to install the package with *.SSISDevelopmentManifest it just genereates a folder in the selected Folder
(...Microsoft SQL Server90DTSPackages) and no more.

What am i missing?

View 5 Replies View Related

Deploy Sqlexpress Through SMS

Jan 10, 2008

Is it possible to deploy sqlexpress to several computers trought SMS (Systems Managements Server)?
Do i need a special version to deply? Do i need to use some specific parameters?

I havent found much information regarding this and would be greatful for all the information i can get. I very new to SMS!

Kind Regards
/Anders

View 1 Replies View Related

Cannot Deploy Report - Please Help

Jan 9, 2007

I am trying to set up Reporting Services. I am using SQL Server 2005 on Win XP Pro.

I installed service pack 2 for SQL Server 2005. The database looks to be set up in the configuration manager. When I try to deploy the report I get the following message:

A connection could not be made to the report server http://localhost/ReportServer

When trying to open the ReportServer folder in IIS I get another message:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Exception has been thrown by the target of an invocation.
Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.

I am not sure what SharePoint is and why I need it. I am just trying to set up simple reports on a local host SQL database and IIS on a standalone PC.

Any help appreciated.

Thanks

View 5 Replies View Related

Deploy Reports

Jun 18, 2007

Hi, i have installed SQL Server Advanced With Reporting Service following the instructions on the SQL video. Everything works fine.

Afther i have make a report with Business Intelligence Studio Express

( using the wizzard ) i try to deploy (local , ISS 5.1 on Win XP SP 2) this report by clicking right mouse on the projectname and then deploy.

In the messagebox : no errors, build and deploying. When i serve to http://localhost/reports..... nothing is changed on the main page and i can't browse to my reports. Can someboy help me.....please

Thanks

View 1 Replies View Related

Sql Exp Adv Srv Deploy Size

Dec 13, 2007

Hi all,

I am deploying the exp w/ adv srv application through downloading.

however, is it so way to trim the adv srv edition to a more reasonalbe size instead of the 2xx MB?

Thanks.

View 1 Replies View Related

Deploy Problem

Mar 14, 2007

I created a package, created an XML Config file, created a deployment utility and then deployed to server.

Changed Connection Managers Data Source and Initial catalog properites during deplyment. Config file in the deployment folder have the right data source and initial catalog properties value.

But when i run the package..I see wrong connection string(still showing dev server name) even though I changed during these properties during deployement and shows it right in configuration file in deployment folder.

From where the package is reading connection properties....very confusing

I will appreciate any help!!!

Amar

View 13 Replies View Related

Deploy SQL Server Express

Mar 19, 2007

Problem: (asp.net 2.0)I x-copy from my development server a database named C:site_testsite.mdf to C:site. When I attach the database with Server Management Studio Express, it list the name as: "C:site_testsite.mdf" eventhough on the live server the database is in the C:site directory and my connection string in my web.config is "C:sitesite.mdf". But everything works until a week later when I need to make a field change to a table on the live site: I'm forced to re-attach the database, but this time it list the database as:C:sitesite.mdf". When I re-attach I get a NT AUTHORITYSERVICE does not have permission. So I give NT AUTHORITYSERVICE permission on the directory and files and ownership with Server Management Stuidio Express, but I still get the error.What am I'm doing wrong? Thanks for the help--Dietrich

View 1 Replies View Related