Email Archiving in E xchange
Hi guys,
Could some point me to some of the best e/mail archiving solution out there.
I am concerned with the way we are creating psts.
Kassoka
Reply:
Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."
Celebrating 20 years of providing Exchange peer support!
------------------------------------
Remote Connectivity - Outlook connectivity failing - The RPC_S_SERVER_UNAVAILABLE error (0x6ba)
First time asking in this furum!
I am getting this error at the remote connectivity site testing outlook connectivity.:
Attempting to ping the MAPI Referral Service endpoint with identity d0e64acf-7fbd-4ca5-a386-742c2d8fa748@xxxxxxxx.xx:6002. The ports are random(6001,6002,6004), guess this is normal?!?
The RPC_S_SERVER_UNAVAILABLE error (0x6ba) was thrown by the RPC Runtime process.
Im have a small hosting setup with 2 exchange 2013 servers. one is MBX and CAS, the other is only MBX. All databases are on the MBX only server. Running with wildcard ssl cert and split dns. Clients can connect but are sometimes complaining about long startup times in outlook. Mobile connectivity seems fine. Autodiscover tests are no problem.
This i have treid are:
Changing from outlook anywhere nagiotiate to basic auth. and ticking off the "allow ssl offlaoding".
Setting INTERNAL NETBIOS and FQDN in host file.
Setting up a dedicated HTTP redirect site on separate server.
Firewall off
I have not completly disabled IPV6, just unchecked it in interface properties. Should i try this? Some blogs says this is not recommended.
Still getting this error.
Anyone have any idees?
- Changed type Mattias AnderssonX Saturday, May 21, 2016 9:01 PM
Reply:
The ports 6001, 6002 and 6004 aren't random, they're fixed.
"Still getting this error." What error?
When citing an entry in the event logs, please post the entire event log entry. You are welcome to use the handy-dandy "copy to clipboard" button in the event log detail window to assist you with this.
Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."
Celebrating 20 years of providing Exchange peer support!
------------------------------------
Reply:
Welcome to Technet forum.
The issue could be caused by the following reasons:
1. Failures in DNS name resolution
2. Missing or invalid ValidPorts key in the registry of the Internet-facing Exchange 2007 Client Access server or of the Exchange 2003 server
3. Exchange services not listening on the required endpoints
4. Firewalls blocking the required ports
We could refer to the following link to troubleshoot:
https://technet.microsoft.com/en-us/library/dd439392(v=exchg.80).aspx
Notice: this link also apply to Exchange 2013.
We suggest you don't disable IPv6 for Exchange server.
Best Regard,
Jim Xu
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.
Jim Xu
TechNet Community Support
------------------------------------
Reply:
Is there any update for this thread?
If that above suggestion solve your issue, please make it as answer so that someone who has similar issue could find this thread as soon as possible.
Best Regard,
Jim Xu
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.
Jim Xu
TechNet Community Support
------------------------------------
Reply:
Hi again,
I still having this issue. Tried these troubleshooting steps but nothig.
I found this article but its so old. Does anyone know if this is applicatble to exchange 2013
http://messagexchange.blogspot.se/2008/12/outlook-anywhere-failing-rpc-end-points.html
------------------------------------
Reply:
You could try it on Exchange 2013.
Best Regard,
Jim Xu
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.
Jim Xu
TechNet Community Support
------------------------------------
Reply:
Is there any update for this thread?
If the above suggestion solve your issue, please mark it as answer so that someone who has similar issue could find this thread as soon as possible.
Best Regard,
Jim Xu
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.
Jim Xu
TechNet Community Support
------------------------------------
Reply:
Still troubleshooting this issue.
I cant wrap my head around the fact that outlook users are not having any problems but when i run outlook connectivity test on RemoteConnectivityAnalyzer site it fails with "Attempting to ping the MAPI Address Book endpoint with identity: d0e64acf-7fbd-4ca5-a386-742c2d8fa748@xxxxxxx.Xx:6004, The RPC_S_SERVER_UNAVAILABLE error (0x6ba) was thrown by the RPC Runtime process"
The thing that bothers me is that this test passed a while ago after installation and all of the sudden it fails. No change to the servers at all.
How can DNS fail after it all worked some time ago. How can there be missing registry keys? These are just things that bothers my, its so frustrating.
------------------------------------
Reply:
update:
i found something that might be the solution. My CAS has muliple IP addresses. When i removed the extra NIC i no more 0x6a error. BUT, now i get another wierd symptom. When running RCA i get this error every other time. Thats right, i get it every other time. Im thinking this could be commiunication error. Anyone got any tips?
------------------------------------
Reply:
Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."
Celebrating 20 years of providing Exchange peer support!
------------------------------------
Reply:
Please make sure port 443 on Exchange CAS server has published to Internet.
Best Regard,
Jim Xu
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.
Jim Xu
TechNet Community Support
------------------------------------
Reply:
I spoke to soon. Today at first test on RCA site still getting the error "The RPC_S_SERVER_UNAVAILABLE error (0x6ba) was thrown by the RPC Runtime process , Attempting to ping the MAPI Referral Service endpoint with identity: d0e64acf-7fbd-4ca5-a386-742c2d8fa748@domain.com:6002"
- Edited by Mattias AnderssonX Tuesday, March 22, 2016 8:27 AM
------------------------------------
Reply:
The RPC validport in regitry on my 2 exchange server are:
Server1 - CAS,MBX
VALIDPORTS
Server1:593;Server1:49152-65535
ValidPorts_AutoConfig_Exchange
localhost:6001;Server1:6001;Server1.ad.domain.com:6001
Server2 - MBX
VALIDPORTS
Server2:593;Server2:49152-65535
ValidPorts_AutoConfig_Exchange
localhost:6001;Server2:6001;Server2.ad.domain.com:6001
Im i missing something here? Should the port 6002 and 6004 be in here somewhere?
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
RDS high availability
Dear All,
I have several questions to ask you regarding RDS 2012 R2.
Most of Company tries to implement RDS in cost effective way.
We can deploy RDS two different ways.
1. All RDS roles in same server
2. Can be used one server per role.
I want to know best RDS high available solution.
Several articles on internet describe only one RDS role for failover(Session host or connection broker)
1. But If i install all RDS roles in same server(Connection Broker, Session Host,Licence), How can I use HA?
2. Can I use hyper-v vm as a clone of my Physical RDS server as HA?
3. Can I use Azure for High available solution of my onprem RDS server
Very much appreciate if you can explain those things and possibility
Reply:
Hi , in order to achieve full HA you should use a SQL Server Cluster for the RD Database. 2 Connection brokers in HA and at least 2 Servers in a collection for the users. You should also configure a Scale out File Server Cluster to store the User Profile Disks and two RD Web and Gateway servers in NLB either Microsoft or 3rd Party.
Yes you can have Physical RDS and VM RDS servers in the same deployment although going all VM would probably be the best option.
Azure is a different story , I would suggest having a separate deployment in Azure although you can technically have some parts of the deployment in Azure , latency would be totally different when connected in your Lan vs Azure.
------------------------------------
Reply:
In order to make your configuration highly available, you can install all RDS roles into a single virtual machine that runs on top of Microsoft Hyper-V Failover Cluster. You need at least two physical servers, obviously, and some shared storage. Using directly attached storage (internal drives) is much better because of latency and performance. This option also eliminates an SPoF that any separate SAN or NAS would be.
To convert your DAS into an HA/FT shared storage for your cluster you can either use Storage Spaces Direct https://technet.microsoft.com/en-us/windows-server-docs/storage/storage-spaces/storage-spaces-direct-overview with Windows 2016 Datacenter or StarWind Virtual SAN https://www.starwindsoftware.com/starwind-virtual-san that is less expensive and does the same.
------------------------------------
some feedback on the rxImport and rxSqlServerData functions
I just tried porting an existing RODBC based project to revoscalr. some things I found that just didn't work:
1. rxDataStep vs rxImport. seems like way too much overlap. I tried to just stick to rxDataStep, but..
2. rxDataStep don't like this SQL query as a source, but rxImport had no problems:
"select IssuerTradingSymbol as Symbol, isnull(nullif(FullName,''), CompanyName) as CompanyName, Sector, Industry, SubIndustry, CompanyName from Issuer"
3. rxImport spits out no rows returned and other messages, even with verbose=0 and reportProgress = 0
4. rxImport returns TRUE if the query returns no rows, vs a data.frame if it does return rows. why cant it just return an empty data.frame? the error handling code on this is mucky
5. rxImport and rxDataStep cannot be used against rxSqlServerData with a stored procedure to fetch data. I had to leave about 50% of my project using rodbc. this seems like a major oversight. I suspect/hope I'm doing something really silly and this isn't a major oversight and the docs can be updated with examples of using a stored procedure
6. The rxExecuteSQLDDL docs states it requires and RxOdbcData, but seems to work fine with rxSqlServerData. the docs should reflect this
7. rxExecuteSQLDDL accepts both DML and DDL. very misleading function name
8. The rxExecuteSQLDDL function can be used to execute a stored procedure that does not return results, HOWEVER, it requires a RxOdbcData or rxSqlServerData as a data source. neither of these objects can bet set up without a source query. To execute a stored procedure, I had to set up the data source with a dummy table name like this:
RxSqlServerData(table = "xxx", connectionString = nativedDbConnection, useFastRead = TRUE)
I think this API design needs some work
I'm glad to see MS doing some work in this space and the product set looks very promising. I hope this feedback is of use
Reply:
Ethan,
Regarding (5):
I'm able to get the results of a stored procedure using RxSqlServerData. Does your procedure happen to PRINT inside it?
I agree with your points above about method inconsistency. FYI, I've wrapped the pattern below inside of a helper function. I'm able to run almost any SQL that I would from RODBC using RxSqlServerData/rxImport (after the NOCOUNT tricks / dummy final result set).
Your post above was the first time I'd tried to use PRINT inside of RxSqlServerData; that does feel like a bug to me and something that should be fixed by Microsoft.
My workaround:
EXEC sp_execute_external_script @language = N'R' , @script = N' # If you want to run multiple statements (and ignore the DDL / SELECT statement nuances) you can use NOCOUNT # However you do need to be careful about error handling # The PRINT statement (or PRINT inside a stored procedure) can cause problems too # The code returns the result set from the *FIRST* query that has one (fairly non-intuitive behavior) ds <- RxSqlServerData(sqlQuery=" SET NOCOUNT ON; /* ARBITRARY SQL HERE */ -- EXEC my_stored_procedure /* this works fine for me */ SET NOCOUNT OFF; SELECT 1 as dummy WHERE 1=0 ", connectionString="Server=.;Database=XXX;uid=XXX;pwd=XXX") r <- rxImport(ds) print(str(r)) ' GO
------------------------------------
Logon problems after migration from SQL Server 2005 to 2012
We have recently migrated the SQL Server from 2005 to 2012. User gets login failure when connected to 2012 server; but can successfully login in 2005 server using the same connection string information. In both the servers, individual user logins are not added.
How access is given to users if not added directly in logins.
Is it right, that the local group SQLServer2005MSSQLUser group is used to grant access to users? Is it possible to view the members of this group?
How this is being handled in 2012 as the security model is changed. I don't have experience in SQL Server and would like to get guidance in fixing this logon problem.
Thanks for the help!
Reply:
Hi Shyam,
No, security model has not been changed in 2012 as compared to 2005.
When you migrated Databases to 2012, did you also migrated logins to 2012? There is special RevLogin script from Microsoft to migrate login between SQL instances.
Thanks,
Kindly mark the reply as answer if they help
------------------------------------
Reply:
Hi Sunil,
Thanks for the reply. I see the logins are same under Security|Logins in both the servers. Also no account has been added individually to the databases security.
The only difference is that I couldn't find equivalence to the local groups SQLServer2005MSFTEUser$ , SQLServer2005MSSQLUser$ and SQLServer2005SQLAgentUser$ in SQL Server 2012. Rather I see NT Service\MSSQLSERVER and NT SERVICE|SQLSERVERAGENT.
Are these above groups linked? Thanks for the response.
Thanks,
Shyam
------------------------------------
Reply:
Hello Shyam,
Actually there's a change in the security model. You have probably upgraded your Windows OS too? Right? Starting with Windows Server 2008 R2, now we have Virtual Accounts and SQL Server uses these Virtual Accounts as a service account, for instance like you mentioned "NT Service\MSSQLSERVER".
Simply, Virtual Accounts are unique instances of the built-in system account Network Service.
You experience login failures, because the new server (I assume you performed the upgrade side by side, not in-place) would not have those local Windows Groups like you have on the server where your SQL Server 2005 instance is.
If you have an Active Directory, create a Windows Group according to your user groups and create Logins in the SQL Server for these Windows Groups and grant permissions accordingly. For instance create a group for Business Analysts, another group for Developerts etc. This way, it's much easier to manage users and permissions. Also, you will not experience such problems you have had next time.
http://ekremonsoy.blogspot.com | http://www.ekremonsoy.com | @EkremOnsoy
------------------------------------
Reply:
We have recently migrated the SQL Server from 2005 to 2012. User gets login failure when connected to 2012 server; but can successfully login in 2005 server using the same connection string information. In both the servers, individual user logins are not added.
How access is given to users if not added directly in logins.
Is it right, that the local group SQLServer2005MSSQLUser group is used to grant access to users? Is it possible to view the members of this group?
How this is being handled in 2012 as the security model is changed. I don't have experience in SQL Server and would like to get guidance in fixing this logon problem.
Thanks for the help!
Use DataBaseName -- Change DatabaseNAme GO EXEC sp_change_users_login 'Auto_Fix', 'UserName' --Replace userName GO
Run above command..
Thanks
______________________________________________________________________
Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers
- Edited by SequelMate Monday, January 9, 2017 2:12 PM
------------------------------------
Reply:
Hi Sunil,
Thanks for the reply. I see the logins are same under Security|Logins in both the servers. Also no account has been added individually to the databases security.
The only difference is that I couldn't find equivalence to the local groups SQLServer2005MSFTEUser$ , SQLServer2005MSSQLUser$ and SQLServer2005SQLAgentUser$ in SQL Server 2012. Rather I see NT Service\MSSQLSERVER and NT SERVICE|SQLSERVERAGENT.
Are these above groups linked? Thanks for the response.
Thanks,
Shyam
Shyam,
I didn't asked but what is the exact error you are getting while logging in on this new 2012 server?
Thanks,
Kindly mark the reply as answer if they help
------------------------------------
Reply:
Did you ensure that SQL Server is using mixed authentication? Right click on your server in Management Studio, select properties and then security. Ensure SQL Server and Windows authentication is checked.
This will explain what you are encountering IF you are using SQL logins.
------------------------------------
MS Office - Appcrash Issue on Windows 2012 R2 Remote Desktop for a single user
Hi All,
Recently I got a report my user saying that he is unable to open any MS Office apps [word/excel ....] in his server. The server is windows 2012 R2 , It has MS Office 2016 with volume Edition enabled. Multiple users can access this Apps in Remote Desktop.
Error was : Appcrash.
I struggled badly . My senior suggested me to have a back up of user profile and delete it.hence issue got fixed .
I wanted to share this with others.- Edited by Maharaj-SysEng Friday, January 6, 2017 9:30 AM
- Changed type Amy Wang_ Monday, January 23, 2017 3:06 PM
Reply:
Hi,
Thank you for sharing the solution with forum community members, it's very beneficial to others who have similar issues.
Best Regards,
Amy
Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
- Edited by Amy Wang_ Monday, January 9, 2017 2:13 PM
------------------------------------
Shared Storage Configuration
I'm setting up a new two node cluster and am new to virtualization. I'm having a hard time figuring out how to configure my storage and how many physical drives and raid arrays I should have and then how many LUNs I should break that down to and then placing the VHDs on top of that. I don't want to put all my eggs in one basket but want to have a configuration that makes sense.
I have a 12-bay MD3200 DAS with (4) 4TB 7.2k SAS Drives and (4) 600GB 15K SAS drives. I also have a bunch of 1TB 7.2K SAS drives I can use and 2 or 3 300GB 10K SAS drives I can use. My original plan was to put the (4) 600GB 15K drives in a RAID 10 and put the SQL data and Log VHDs on it using two LUNS each with a VHD on it. Then use the (4) 4TB drives in a RAID 10 for everything else (VMs and VHDs). I'm starting to question if I should have more RAID Arrays then this. For Instance, should I do (2) separate 600GB RAID 1s, one for SQL Data, One for Logs? Should I have (2) separate 1TB RAID1s for the Exchange data and logs? Here are the VMs I'm setting up, if you can make any drive recommendations for what drives to put in my Power Vault, what RAID arrays I should Create and how many LUNs I should setup for my shared storage I'd appreciate it. Below are the VMs I'm going to be creating.
SharePoint
SQL
Exchange
RDS
Office Online Server
File and Print Share Server
Reply:
i'm not familiar with that storage enclosure and how it's managed but if it allows you to create a storage pool where it does auto-tiering, it would certainly simplify things
i agreed with RAID 10 only for your SQL workloads
everything else you should use RAID 5 or RAID 6
not knowing your space requirements makes it challenging to make a detailed recommendation
------------------------------------
Reply:
------------------------------------
Reply:
the more RAIDs you create, the less capacity you will have as you lose more drives for redundancy
7.2k can be quite slow, i would try to use up your 10k in one RAID and 15k drives in separate RAID but take capacity expansion into consideration as well if you need to add more drives later on within the same enclosure
it's certainly not necessary to have a 1:1 ratio of VHD and LUN. the whole point of CSVs in clustering is to let you share a LUN among multiple VHDs
if you had a larger SAN you could argue to have more LUNs to balance workloads and performance but i would say 2 LUNs max per RAID here. everything is going to the same back-end so you won't really gain much in terms of performance
------------------------------------
Reply:
------------------------------------
Reply:
i would not recommend a mirror RAID 1 for SQL or most workloads for that matter. the less drives you have in your array, the slower the performance will be
you can see here that RAID 10 seems to be the best fit for SQL performance as well as redundancy:
https://technet.microsoft.com/en-us/library/ms190764(v=sql.105).aspx
RAID 5 is the best choice after that and usually a comfortable configuration for other workloads which are not as write-intensive as SQL
separating your SQL data into multiple VHDs is fine as well, mostly just for better managing disk space growth for system DBs, app DBs, log, temp, etc.
------------------------------------
Reply:
The less virtual volume groups you have, the better.
Go with 2-3: 15K drives in RAID 10 for SQL, the 1 TB bunch - RAID10 for everything else (the more you have the better the performance) and leave the 4 TB as RAID10 for infrequently accessed stuff. RAID5 is too risky, and RAID6 at 4 drives gives you the same capacity as RAID10.
------------------------------------
Lync 2010 - CTRL+V (Paste) and Other Edit Shortcuts Do Not Work
Using Lync 2010 - In the IM conversation window, CTRL+V and other CTRL+<key> shortcuts do not work. Right click using a mouse and selecting 'Paste' or 'Copy', etc, in the drop down menu all work correctly however. The 'Delete' key does not work either but my 'Backspace' key works fine.
This is annoying but tolerable - just wondering if anyone knows what the problem is or if there's a fix or a workaround.
Thanks.
Reply:
according to this:
http://social.technet.microsoft.com/Forums/en-US/ocsclients/thread/484e32a9-5010-42c1-ba02-063edefb9432
this can happen sometimes. just restart Lync and it will fix it.
+Say thanks and observe basic forum courtesy:
+If this post answered your question, Mark As Answer
+If this post was helpful, Vote as Helpful
windowspbx blog: my thots/howtos
see/submit Lync suggestions here: simple and public
------------------------------------
Reply:
------------------------------------
Reply:
MCSD
------------------------------------
Reply:
Hi, it's 2016 but still no reply :)
Did anyone find a solution for this bug ?
I still can't use the keyboard shortcuts (Ctrl+C, Ctrl+V, Esc, ...) in Microsoft Lync 2010 with Windows 8
- Edited by Edith Khattar Monday, January 9, 2017 7:49 AM
------------------------------------
Missing the Reply button in a Sharepoint 2010 discussion
Hi,
when I use the "Add a new discussion" link, it create correctly the new threat, but without the Replay button. I'm using Shrepoint 2010, do you know how I can solve this?
Thanks
Reply:
http://marijnsomers.blogspot.com || @marijnsomers
------------------------------------
Reply:
Hi Marijin
I'm not sure what you are asking, how can i see that?
------------------------------------
Reply:
Check the list permissions. Perhaps you have a special kind of permission? (only add, no edit)
You can see that on list or site settings (depending if your list inherits the site security or not)
http://marijnsomers.blogspot.com || @marijnsomers
------------------------------------
Reply:
I have the same problem with recent treads. The old threads still have the reply button.
It might due to some add/remove of columns or content types; however it is so difficult for me to find out what's wrong or how to fix it.
------------------------------------
Upgrade to scom 2012 R2 failed
Hello all
The upgrade of scom 2012 R2 from scom 2012 SP1 RU10 has failed.
It failed during MP import with the following error:
[12:16:43]: Always: :FirstManagementServer: CreateConnector in preparation for Networking MP import.
[12:17:24]: Always: :DBUPgrade: Create Networking Connector.
[12:18:16]: Error: :Error:CreateConnector failed networking connector
[12:18:16]: Error: :ImportManagementPacks failed with the following exception: : Threw Exception.Type: System.Reflection.TargetInvocationException, Exception Error Code: 0x80131604, Exception.Message: Exception has been thrown by the target of an invocation.
[12:18:16]: Error: :StackTrace: at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Delegate.DynamicInvokeImpl(Object[] args)
at Microsoft.EnterpriseManagement.SetupFramework.ActionEngine.Action.Run(String displayStringNamespace, ProgressData progressData, Func`2 progressDelegate)
at Microsoft.EnterpriseManagement.SetupFramework.ActionEngine.InstallStep.Run(String displayStringNamespace, ProgressData progressData, Func`2 progressDelegate)
[12:18:16]: Error: :Inner Exception.Type: System.ApplicationException, Exception Error Code: 0x80131604, Exception.Message: CreateConnector for networking failed
[12:18:16]: Error: :InnerException.StackTrace: at Microsoft.SystemCenter.Essentials.SetupFramework.InstallItemsDelegates.OMDatabaseProcessor.CreateConnectors(String setupLog, String connectorName, String connectorDescription)
at Microsoft.SystemCenter.Essentials.SetupFramework.InstallItemsDelegates.OMDatabaseProcessor.CreateConnectors(String setupLog, String connectorName, String connectorDescription)
at Microsoft.SystemCenter.Essentials.SetupFramework.InstallItemsDelegates.OMDatabaseProcessor.ImportManagementPacks(String installMode, ProgressData progressData, Func`2 progressDelegate)
[12:18:16]: Error: :FATAL ACTION: ImportManagementPacks
[12:18:16]: Error: :FATAL ACTION: DatabaseActions
[12:18:16]: Error: :ProcessInstalls: Running the PostProcessDelegate returned false.
[12:18:16]: Always: :SetErrorType: Setting VitalFailure. currentInstallItem: Database Configuration
[12:18:16]: Error: :ProcessInstalls: Running the PostProcessDelegate for OMDATABASE failed.... This is a fatal item. Setting rollback.
[12:18:16]: Info: :SetProgressScreen: FinishMinorStep.
[12:18:16]: Always: :!***** Installing: OMSERVER ***
[12:18:16]: Info: :ProcessInstalls: Rollback is set and we are not doing an uninstall so we will stop processing installs
[12:18:16]: Always: :****************************************************************
[12:18:16]: Always: :****Starting*RollBack*******************************************
[12:18:16]: Always: :****************************************************************
Thank you for your advise.
TechNet
Reply:
Hi Sir,
Have you followed the following article regarding SCOM upgrade :
https://technet.microsoft.com/en-us/library/dn249707.aspx
http://www.systemcentercentral.com/upgrading-operations-manager-from-2012-sp1-to-2012-r2-step-by-step-upgrading-to-2012-r2-series/
Best Regards,
Elton
Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
------------------------------------
Reply:
I guess this is a duplicate of the below question by the same user.
https://social.technet.microsoft.com/Forums/en-US/95e809ca-fb31-4fd5-9000-ab663290c3f7/upgrade-to-scom-2012-r2?forum=operationsmanagerdeployment
Can any Moderator close this thread.
Gautam.75801
------------------------------------
Microsoft Office Professional Plus 2013 Error code 0-1012 (0)
windows 8.1 to Windows prof upgrade
hi
we have received win8.1 pre loaded os instead windows 10 prof. later oem has given windows 10 prof licenses key. with this key we are able to activate fresh installation only. when we are trying to upgrade from win8.1 to win10 prof, given key is not useful.can some one help on this..
Reply:
S.Sengupta, Windows Insider MVP
------------------------------------
I forgot My EXCEL password
Hi all
I was forgot my excel 2010 password , I tried a lot of programs and no one is help me.
I need the data which inside this file, so please help me to get this.
thank you,,
- Changed type Max Meng Tuesday, September 18, 2012 2:57 AM Password recovery
Reply:
check this link this may help you out
http://www.online-tech-tips.com/ms-office-tips/how-to-remove-crack-or-break-a-forgotten-excel-xls-password/
------------------------------------
Reply:
------------------------------------
Reply:
hi, did you managed to find something? i have the same problem..
thanks
------------------------------------
Here's how you can still get a free Windows 10 upgrade
Failed to load images in SQL datawarehouse using java
We are trying to load images(size more than 8 KB) in the sql datawarehouse using jdbc driver.
We are getting below error while loading data in SQL datawarehouse.
com.microsoft.sqlserver.jdbc.SQLServerException: The size (21796912) given to the type 'varbinary' exceeds the maximum allowed for any data type (8000)
The table definition is given below
create table dbo.test_varbin_type1
(
id bigint,
binary_lob varbinary (max)
)
WITH
(
DISTRIBUTION = HASH (id),
CLUSTERED INDEX( id)
);
Reply:
The JDBC type should be LONGVARBINARY.
https://msdn.microsoft.com/en-us/library/ms378813(v=sql.110).aspx
-- Paul Wehland (MCM-SQL) Avanade GmbH
------------------------------------
Reply:
Thanks Paul for sharing the link. However I am still getting the same error. Am I missing something here?
String filePath = "D:/Photo/world.jpg";try {
Connection conn = DriverManager.getConnection(connectionString);
String sql = "INSERT INTO dbo.test_varbin_type_test1 (fname, binary_lob) values (?, ?)";
PreparedStatement statement = conn.prepareStatement(sql);
//statement.(1, 1);
statement.setString(1, "Rajib");
InputStream inputStream = new FileInputStream(new File(filePath));
statement.setBinaryStream(2, inputStream);
int row = statement.executeUpdate();
inputStream.close();
if (row > 0) {
System.out.println("A contact was inserted with photo image.");
}
conn.close();
} catch (SQLException ex) {
ex.printStackTrace();
} catch (IOException ex) {
ex.printStackTrace();
}
}
------------------------------------
Reply:
Could you try inserting a file via SSMS or SSDT? I tried to repro this directly and it worked just fine.
-Casey
------------------------------------
Populate 'to' address of recieved email with another email address
Hi,
We have email routed from one Exchange Online Mailbox to another. The routed email comes from a secondary mailbox that is seldom used. We have email integration with dynamics CRM Online which checks the 'to' address of mail in the inbox to make sure it matches the address set-up in CRM.
The issue is the email routed from the secondary mailbox doesn't contain the 'to' address of the Mailbox it's being forwarded to and therefore is ingored by CRM. Is there a way to populate the 'to' address with the Mailbox address of the Mailbox the email is being forward to.
e.g. Box2 is routing Email to Box1. The Mail routed to Box1 has the original 'to' value populated when recieved in Box2. We need the 'to' value of email being routed to box 1 to contain the address of Box1 as well or in place of the Box 2 Address that is populated on the original email.
Reply:
------------------------------------
SQL '16 Dev installation failed! ; SqlEngineConfigAction_install_confignonrc_Cpu64
Hello Alex!
As the other people over here I have the same problem!
======================================================================================
And Also the LOG file!
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2068119551
Start time: 2017-01-01 23:12:19
End time: 2017-01-01 23:43:54
Requested action: Install
Setup completed with required actions for features.
Troubleshooting information for those features:
Next step for RS: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Next step for Polybase: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Next step for SQLEngine: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Next step for DQ: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Next step for FullText: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Next step for AdvancedAnalytics: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Next step for Replication: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Machine Properties:
Machine name: DESKTOP-TD5CIIB
Machine processor count: 8
OS version: Microsoft Windows 10 Pro (10.0.14393)
OS service pack:
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered Configured
SQL Server 2016 SSMS 1033 13.0.16100.1 No Yes
SQL Server 2016 Adv_SSMS 1033 13.0.16100.1 No Yes
Package properties:
Description: Microsoft SQL Server 2016
ProductName: SQL Server 2016
Type: RTM
Version: 13
Installation location: C:\sql_server2016\x64\setup\
Installation edition: Developer
Slipstream: True
SP Level 1
Product Update Status:
Success: KB 3182545
Product Updates Selected for Installation:
Title: Microsoft SQL Server 2016 with SP1
Knowledge Based Article: KB 3182545
Version: 13.1.4001.0
Architecture: x64
Language: 1033
Update Source: Slipstream
User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: false
AGTSVCACCOUNT: NT Service\SQLSERVERAGENT
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Manual
ASBACKUPDIR: C:\Program Files\Microsoft SQL Server\MSAS13.MSSQLSERVER\OLAP\Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: C:\Program Files\Microsoft SQL Server\MSAS13.MSSQLSERVER\OLAP\Config
ASDATADIR: C:\Program Files\Microsoft SQL Server\MSAS13.MSSQLSERVER\OLAP\Data
ASLOGDIR: C:\Program Files\Microsoft SQL Server\MSAS13.MSSQLSERVER\OLAP\Log
ASPROVIDERMSOLAP: 1
ASSERVERMODE: MULTIDIMENSIONAL
ASSVCACCOUNT: NT Service\MSSQLServerOLAPService
ASSVCPASSWORD: <empty>
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: DESKTOP-TD5CIIB\wmuts, DESKTOP-TD5CIIB\Administrator
ASTELSVCACCT: NT Service\SSASTELEMETRY
ASTELSVCPASSWORD: <empty>
ASTELSVCSTARTUPTYPE: Automatic
ASTEMPDIR: C:\Program Files\Microsoft SQL Server\MSAS13.MSSQLSERVER\OLAP\Temp
BROWSERSVCSTARTUPTYPE: Disabled
CLTCTLRNAME:
CLTRESULTDIR: C:\Program Files (x86)\Microsoft SQL Server\DReplayClient\ResultDir\
CLTSTARTUPTYPE: Manual
CLTSVCACCOUNT: NT Service\SQL Server Distributed Replay Client
CLTSVCPASSWORD: <empty>
CLTWORKINGDIR: C:\Program Files (x86)\Microsoft SQL Server\DReplayClient\WorkingDir\
COMMFABRICENCRYPTION: 0
COMMFABRICNETWORKLEVEL: 0
COMMFABRICPORT: 0
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20170101_231219\ConfigurationFile.ini
CTLRSTARTUPTYPE: Manual
CTLRSVCACCOUNT: NT Service\SQL Server Distributed Replay Controller
CTLRSVCPASSWORD: <empty>
CTLRUSERS: DESKTOP-TD5CIIB\wmuts, DESKTOP-TD5CIIB\Administrator
ENABLERANU: false
ENU: true
EXTSVCACCOUNT: NT Service\MSSQLLaunchpad
EXTSVCPASSWORD: <empty>
FEATURES: SQLENGINE, REPLICATION, ADVANCEDANALYTICS, FULLTEXT, DQ, POLYBASE, AS, RS, SQL_SHARED_MR, RS_SHP, RS_SHPWFE, DQC, CONN, IS, BC, SDK, BOL, DREPLAY_CTLR, DREPLAY_CLT, MDS
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: NT Service\MSSQLFDLauncher
FTSVCPASSWORD: <empty>
HELP: false
IACCEPTROPENLICENSETERMS: true
IACCEPTSQLSERVERLICENSETERMS: true
INDICATEPROGRESS: false
INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\
INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\
INSTALLSQLDATADIR: <empty>
INSTANCEDIR: C:\Program Files\Microsoft SQL Server\
INSTANCEID: MSSQLSERVER
INSTANCENAME: MSSQLSERVER
ISSVCACCOUNT: NT Service\MsDtsServer130
ISSVCPASSWORD: <empty>
ISSVCSTARTUPTYPE: Automatic
ISTELSVCACCT: NT Service\SSISTELEMETRY130
ISTELSVCPASSWORD: <empty>
ISTELSVCSTARTUPTYPE: Automatic
MATRIXCMBRICKCOMMPORT: 0
MATRIXCMSERVERNAME: <empty>
MATRIXNAME: <empty>
MRCACHEDIRECTORY:
NPENABLED: 0
PBDMSSVCACCOUNT: NT AUTHORITY\NETWORK SERVICE
PBDMSSVCPASSWORD: <empty>
PBDMSSVCSTARTUPTYPE: Automatic
PBENGSVCACCOUNT: NT AUTHORITY\NETWORK SERVICE
PBENGSVCPASSWORD: <empty>
PBENGSVCSTARTUPTYPE: Automatic
PBPORTRANGE: 16450-16460
PBSCALEOUT: false
PID: *****
QUIET: false
QUIETSIMPLE: false
ROLE:
RSINSTALLMODE: DefaultNativeMode
RSSHPINSTALLMODE: SharePointFilesOnlyMode
RSSVCACCOUNT: NT Service\ReportServer
RSSVCPASSWORD: <empty>
RSSVCSTARTUPTYPE: Automatic
SAPWD: <empty>
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: Latin1_General_CI_AS
SQLSVCACCOUNT: NT Service\MSSQLSERVER
SQLSVCINSTANTFILEINIT: false
SQLSVCPASSWORD: <empty>
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: DESKTOP-TD5CIIB\wmuts, DESKTOP-TD5CIIB\Administrator
SQLTELSVCACCT: NT Service\SQLTELEMETRY
SQLTELSVCPASSWORD: <empty>
SQLTELSVCSTARTUPTYPE: Automatic
SQLTEMPDBDIR: <empty>
SQLTEMPDBFILECOUNT: 8
SQLTEMPDBFILEGROWTH: 64
SQLTEMPDBFILESIZE: 8
SQLTEMPDBLOGDIR: <empty>
SQLTEMPDBLOGFILEGROWTH: 64
SQLTEMPDBLOGFILESIZE: 8
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SUPPRESSPRIVACYSTATEMENTNOTICE: false
TCPENABLED: 0
UIMODE: Normal
UpdateEnabled: true
UpdateSource: Slipstream
USEMICROSOFTUPDATE: false
X86: false
Configuration file: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20170101_231219\ConfigurationFile.ini
Detailed results:
Feature: Client Tools Connectivity
Status: Passed
Feature: Client Tools SDK
Status: Passed
Feature: Client Tools Backwards Compatibility
Status: Passed
Feature: Reporting Services - Native
Status: Failed: see logs for details
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x84BB0001
Error description: Attempted to perform an unauthorized operation.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.4001.0&EvtType=0x48BB60BC%400xBB814387&EvtType=0x48BB60BC%400xBB814387
Feature: PolyBase Query Service for External Data
Status: Failed: see logs for details
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x84BB0001
Error description: Attempted to perform an unauthorized operation.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.4001.0&EvtType=0x48BB60BC%400xBB814387&EvtType=0x48BB60BC%400xBB814387
Feature: Database Engine Services
Status: Failed: see logs for details
Reason for failure: An error occurred during the setup process of the feature.
Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x84BB0001
Error description: Attempted to perform an unauthorized operation.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.4001.0&EvtType=0x48BB60BC%400xBB814387&EvtType=0x48BB60BC%400xBB814387
Feature: Data Quality Services
Status: Failed: see logs for details
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x84BB0001
Error description: Attempted to perform an unauthorized operation.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.4001.0&EvtType=0x48BB60BC%400xBB814387&EvtType=0x48BB60BC%400xBB814387
Feature: Full-Text and Semantic Extractions for Search
Status: Failed: see logs for details
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x84BB0001
Error description: Attempted to perform an unauthorized operation.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.4001.0&EvtType=0x48BB60BC%400xBB814387&EvtType=0x48BB60BC%400xBB814387
Feature: R Services (In-Database)
Status: Failed: see logs for details
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x84BB0001
Error description: Attempted to perform an unauthorized operation.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.4001.0&EvtType=0x48BB60BC%400xBB814387&EvtType=0x48BB60BC%400xBB814387
Feature: SQL Server Replication
Status: Failed: see logs for details
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x84BB0001
Error description: Attempted to perform an unauthorized operation.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.4001.0&EvtType=0x48BB60BC%400xBB814387&EvtType=0x48BB60BC%400xBB814387
Feature: Master Data Services
Status: Passed
Feature: Distributed Replay Client
Status: Passed
Feature: Distributed Replay Controller
Status: Passed
Feature: Integration Services
Status: Passed
Feature: Data Quality Client
Status: Passed
Feature: Analysis Services
Status: Passed
Feature: Reporting Services - SharePoint
Status: Passed
Feature: Reporting Services Add-in for SharePoint Products
Status: Passed
Feature: SQL Browser
Status: Passed
Feature: Documentation Components
Status: Passed
Feature: SQL Writer
Status: Passed
Feature: R Server (Standalone)
Status: Passed
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20170101_231219\SystemConfigurationCheck_Report.htm
=====================================================================================
THANKS!
The best for the new year!
Wim Mutsaers
Reply:
Hello Alex!
I have the same problem and I can't get a fix or a workaround! Here are some images! I also called MS here in the Netherlands, no luck! And I can't afford $499 Dollars!
======================================================================================
Please Advise!
A good new 2017!
Greetings Wim Mutsaers
- Edited by wmutsaers Monday, January 2, 2017 3:41 PM
- Merged by Alberto MorilloMVP Monday, January 2, 2017 6:41 PM Duplicate thread
------------------------------------
Reply:
Reference:
SQL Server 2016 express install error: attempted to perform an unauthorized operation
Kalman Toth Database & OLAP/AI Architect SQL Server 2016 Database Design
New Book : Beginner Database Design & SQL Programming Using Microsoft SQL Server 2016
------------------------------------
Reply:
Duplicate post. It should be deleted.
Kalman Toth Database & OLAP/AI Architect SQL Server 2016 Database Design
New Book : Beginner Database Design & SQL Programming Using Microsoft SQL Server 2016
- Edited by Kalman Toth Monday, January 2, 2017 4:10 PM
------------------------------------
Reply:
Do you have a chance for a retry? But this time, right click on the Setup.exe and "run as administrator".
If you hit the same problem again, setup logs would be useful for further investigation.
http://ekremonsoy.blogspot.com | http://www.ekremonsoy.com | @EkremOnsoy
------------------------------------
Reply:
Hello,
Please copy the media (F:\ drive) to a new folder on the local disk (C:\SQLTemp\), unzip ISO file, if necessary, and run SQL Server setup with the Run As Administrator option.
On the Server Configuration page of SQL Server 2016 setup, could you please use "Local System" as the service account instead of the default service accounts or provide a Windows account with administrator privileges and a strong password. For more information, please read the following article:
http://www.sqlcoffee.com/SQLServer2016_0001.htm
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
------------------------------------
Reply:
I'm having the exact same problem.
I tried installing 2012 from an ISO and mounted the ISO as a drive. I am now trying to install 2016 Dev version downloaded from the Microsoft Dev Essentials website. The install has failed using both media sources. I have run both installs as administrator and also as the machine local admin.
This is therefore probably an issue with Windows rather than the installation settings of SQL. It is blocking setting values in the registry during the configuration setup at the end of the installation. I read on a different forum that the solution is to reinstall windows. I can't afford to do that so am still searching for a solution.
Would using "Local System" account rather than the setup defaults affect the installation failing, wouldn't it would just change the account SQL runs under if or when the installation succeeds?
------------------------------------
Reply:
Hello there,
You found a solution? If not, when checking the log portion again, I see that you added every one of the services. Of course it's not a crime, but I suspect that installation one of those new services might be faulty. So, can you try the installation only with the Database Engine? And then, you may want to try to add the other services one by one, so we can find out which is the problematic one, if my guesswork is right...
http://ekremonsoy.blogspot.com | http://www.ekremonsoy.com | @EkremOnsoy
------------------------------------
JDBC Eclipse
Hi,
I am trying to use the JDBC driver with Eclipse IDE to connect to a SQL Server on Linux instance.
Here is my code so far
public static void SQLtest() { String userName = "SA"; String password = "****"; String url = "jdbc:sqlserver://192.168.254.16:1434;integratedSecurity=true;"; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); } catch (ClassNotFoundException e) { System.out.println("Finding Driver Failed"); e.printStackTrace(); } try { System.out.println("Establishing Database Connection..."); Connection conn = DriverManager.getConnection(url, userName, password); } catch (SQLException e) { System.out.println("Connection Failed"); e.printStackTrace(); } finally { System.out.println("Connection Successful!"); } } and here is the error that I get...
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 192.168.254.16, port 1434 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
Conditional Acess with Exchange on-prem and Sony/LG Devices
I've experienced this problem for the past 6 months and Microsoft's support seems to be ignorant when it comes to resolving this particular problem.
To summarize my problem:
I manage thousands of mobile devices with Microsoft Intune (Standalone) where most of them are enforced by Conditional Access policies, both Android and iOS
There seems to be a handful of Sony and LG devices that are being blocked by Conditional Access regardless of EAS Activation and there is no way around it.
I've had several tickets regarding the matter but we never seem to come to a conclusion.
Are anyone else also experiencing this problem?
Reply:
What does this mean? Are you receiving the activation email? What happens on the devices?There seems to be a handful of Sony and LG devices that are being blocked by Conditional Access regardless of EAS Activation and there is no way around it.
Gerry Hampson | Blog: www.gerryhampsoncm.blogspot.ie | LinkedIn: Gerry Hampson | Twitter: @gerryhampson
------------------------------------
Reply:
Devices receives activation email, but the device is never removed from quarantineThere seems to be a handful of Sony and LG devices that are being blocked by Conditional Access regardless of EAS Activation and there is no way around it.
What does this mean? Are you receiving the activation email? What happens on the devices?
Gerry Hampson | Blog: www.gerryhampsoncm.blogspot.ie | LinkedIn: Gerry Hampson | Twitter: @gerryhampson
------------------------------------
where clause error
i have this code
Select p_firstname, p_email
From teacher as t inner join borrowed as b
where t.p_id = b.p_id;
and it gives 'Record Count: 0'
note: the code is correct
- Edited by Anas.zahab Tuesday, December 27, 2016 8:05 PM
Reply:
Using an inner join clause requires you to provide the conditions for joining using "on":
select ... from t inner join b on t.x = b.x order by ...;
And for future reference, please choose the forum that is most appropriate for your question. This has no relationship to the .net framework. In addition, no one can read your mind or see your screen. Comments like "gives me error" are not useful - post the complete error message.
------------------------------------
Reply:
thank you so much for replying, but unfortunately still not working.
I am sorry about my forum but this is my first time here and I do not know the right forum (if you can tell me thanks )
thanks for the advise
------------------------------------
Reply:
Change your code like:
Select p_firstname, p_email
From teacher as t, borrowed as b
where t.p_id = b.p_id;
or
Select p_firstname, p_email
From teacher as t inner join borrowed as b
on t.p_id = b.p_id;
As scott_morris-ga said, if you are going to use JOIN keyword then you must use ON as a filtering predicate.
http://ekremonsoy.blogspot.com | http://www.ekremonsoy.com | @EkremOnsoy
------------------------------------
Reply:
try below:
select t.p_firstname, b.p_email from teacher as t inner join borrowed as b on t.p_id = b.p_id;
or
select t.p_firstname, b.p_email from teacher as t inner join borrowed as b on t.p_id = b.p_id where condition;
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
No comments:
Post a Comment