berbagisolusi
sqlserver
Publish Reporting Service SQL Server 2005 in ASP.NET
A. CREATE REPORT (.rdl) 1. Create new project from VS2005 (installer from SQL Server 2005), NEW > Business Intelelligence Projects > Report Server Project 2. At Solustion Explorer right pane, right click Report > Add New Report >. Set your dataset and query. 3. Using tab dataset if you want add new Dataset 4. Parameter. … Continue reading
Cannot use the special principal ‘sa’ (Error: 15405) MsSQL Server
Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 ERROR: Cannot use the special principal ‘sa’. Microsoft SQL Server, Error: 15405 SOLUTION: run this command in the query editor window for each database exec sp_changedbowner ‘sa’,’true’ _____________________________________________________________ I Have this issue running SQL Server 2008 and this message was in the log: “Login … Continue reading
Getting Client IP Address from SQL Server
First you must open blocked xp_cmdshell command sp_configure ‘show advanced options’,1 GO RECONFIGURE GO sp_configure xp_cmdshell,1 GO RECONFIGURE You can try this action to check your reconfigure is active and already use EXEC master.dbo.xp_cmdshell ‘ipconfig’ Second, please copy this procedure to getting IP address after SQL Server resulting client HOST NAME : USE [dbname] GO … Continue reading
MsSQL Server (Error : Connection Timeout) or (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )
1. HOST If you have that’s problem first check your host. If you didn’t success made connection using IP addres, try using YOURHOSTNAME/SERVICE_NAME Example your IP 192.168.1.111, and your host : TheGeek-Area, sqlserver service NETSQLSERVER, then you can write the host is TheGeek-Area/NETSQLSERVER 2. SQL Server should be up and running. Go to All Programs … Continue reading
Web Statistic
berbagisolusi 